Date forcasting

[bigbaded]

I am trying to find a way to forcast dates from a from a specified start date, e.g. 9-week, 14-week etc.

I can use EDATE to forcast monthly dates but am struggling with weekly forcasting.

Please help!

 

[DonkeyOte]

In the cell that you want to be date & 7 weeks or whatever...simply do the following formula (assuming a1 to be startd date):

=a1+(7*7) where the first 7 is the weeks so if this was in a cell (i.e. it changed because it's the result of a formula itself and is in b1) - it would be =a1 + (b1 * 7)