View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
David Biddulph[_2_] David Biddulph[_2_] is offline
external usenet poster
 
Posts: 8,651
Default 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?