| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| importing Word document into Excel 2002 worksheet. | Excel Worksheet Functions | |||
| Outlook 2002 calendar dates exported to Excel 2002 sort incorrectl | Excel Worksheet Functions | |||
| Excel 2002 document not opening with a proper view in Excel 2003 | New Users to Excel | |||
| Creating custom colours in Excel 2002 | Excel Discussion (Misc queries) | |||
| creating a document from an Excel row | Excel Discussion (Misc queries) | |||
Hybrid Mode
