Formula to generate series of dates
Does anyone know how to write a formula to have a series of dates generated based on entry of a starting date? In excel, you can enter starting date of 5/1/23, the next cell can can be +7 days so the date is auto generated to be 5/8/23, 5/15/23 etc. I can't figure out how to do this to save time for user since they have to manually enter. Sheet Sample below. I have named each column by WK#. However this column is NOT a date column because if I make it date column, then I cannot simply enter a NUMBER VALUE in that column. In row 2 (RED), I would like a way to have the week date auto generated for those cells ONLY. 5/1/23, 5/8,23, 5/15,23 etc.. Would love to see if anyone has tips or suggestions. Thank you
Help Article Resources
Check out the Formula Handbook template!