Hi wonder if this can be done in a formula or would it have to be vba. Looking to only generate the dates based on the number of weeks. Currently the spreadsheet shows 20 weeks, but if there is only 5 weeks I don't want to have go and delete the formula in case the dates change. The current formula WK1 = Start date + 7, WK2 = WK1 + 7, so on and so forth. Example below....
|Start Date</SPAN>||Est. End Date</SPAN>|| # of Weeks|
|Est. Open Date</SPAN>||Week 1</SPAN>||Week 2</SPAN>||Week 3</SPAN>|