FUNCTION/FORMULA or VBA: Copying Across Cells

[smac001]

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 </SPAN>	Est. Open Date</SPAN>	Week 1</SPAN>	Week 2</SPAN>	Week 3</SPAN>
3/18/13</SPAN>	4/23/13</SPAN>	5</SPAN>	4/26/13</SPAN>	3/25/13</SPAN>	4/1/13</SPAN>	4/8/13</SPAN>

<TBODY>
</TBODY><COLGROUP><COL span=2><COL><COL><COL><COL><COL></COLGROUP>

 

[Robert Mika]

Based on start date in cell A2(adjust as you need)
=IF(COLUMNS($A$2:A2)>$C2,"",$A$2+COLUMNS($A$1:A1)*7)
Drag down and accross

 

[smac001]

Hi the formula works, I have another condition in the cell to only display the date if cell g is less than today's date however when I test it does not work. Would you be able to assist? Here is the formula =IF(G26<="()TODAY","",IF(COLUMNS($G$6:G6)>$I6,"",$G$6+COLUMNS($G$3:G3)*7))