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.

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" <MosMash@discussions.microsoft.com> wrote in message
news:61FB2E8E-77AA-44E8-95ED-71413F8AEC34@microsoft.com...
> My question is simple:
> How can I calculate a future or past date in Excel? I tried "EDATE" but
> didn't work.
> Thanks.

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" <MosMash@discussions.microsoft.com> wrote in message
news:61FB2E8E-77AA-44E8-95ED-71413F8AEC34@microsoft.com...
> My question is simple:
> How can I calculate a future or past date in Excel? I tried "EDATE" but
> didn't work.
> Thanks.