In A1 enter the date
In A2 enter the formula =A1+7 and copy the cell down as required....

If this post helps click Yes
---------------
Jacob Skaria


"jenniss" wrote:

Many thanks, that works

Is there anyway of taking a shortcut so i dont have to caluculate the date
in 52 differnt cells they all all underneath eachother if that helps

"Jacob Skaria" wrote:

With a date in A1 (excel date format)

Try the below formula in A2 to display the date after 1 week. Format this
cell (A2 ) to date format...
=A1+7

If this post helps click Yes
---------------
Jacob Skaria


"jenniss" wrote:

I am trying to create a document to calulate a series of dates:

Service date: 17 July 2009

1 week =
2 weeks =
3 weeks +
etc
etc

It basically needs to calculate what the date will be after 1 week to 52
weeks from the service date (hopefuly that will be enough)

Can anybody tell me how to do this?