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

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?

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

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

"jenniss" wrote in message
...
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?

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

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?

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

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?

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

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?

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

Copy down.
--
David Biddulph

"jenniss" wrote in message
...
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?