creating an new excel document (2002) to work out dates

[jenniss]

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?

 

[David Biddulph]

If your starting date is in A1 (and is a real date, not text)
In A2 put the formula =A1+7 and copy down.

 

[Jacob Skaria]

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

 

[jenniss]

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]

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

 

[David Biddulph]

Copy down.
--
David Biddulph

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