| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How do I Calculate a future or past date in Excel?
My question is simple:
How can I calculate a future or past date in Excel? I tried "EDATE" but didn't work. Thanks. |
|
#2
|
|||
|
|||
|
With a date in Cell A1, you can put =A1+7 to get one week later, or =A1-7 to
get one week earlier. Add any number, and it adds that many days to your date. ******************* ~Anne Troy www.OfficeArticles.com www.MyExpertsOnline.com "MosMash" wrote in message ... My question is simple: How can I calculate a future or past date in Excel? I tried "EDATE" but didn't work. Thanks. |
|
#3
|
|||
|
|||
|
For Edate formula to work you need to install (or activate) the "analysis
toolpak" add-in. The system will tell you whether you need the office suite cd. Depends which options you used when you first installed excel. -- Greetings from New Zealand Bill K "MosMash" wrote in message ... My question is simple: How can I calculate a future or past date in Excel? I tried "EDATE" but didn't work. Thanks. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| calculate anniversary of date after specified date | Excel Worksheet Functions | |||
| Excel enters date as a text format | Excel Discussion (Misc queries) | |||
| How do I enter the date last modified in the footer of an Excel d. | Excel Discussion (Misc queries) | |||
| Excel: Is there a way to calculate the date as week of month? | Excel Discussion (Misc queries) | |||
| Creating a Date Selector in Excel VBA? | Excel Discussion (Misc queries) | |||
Linear Mode
