How do I Calculate a future or past date in Excel?

[MosMash]

My question is simple:
How can I calculate a future or past date in Excel? I tried "EDATE" but
didn't work.
Thanks.

 

[Anne Troy]

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

 

[Bill Kuunders]

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.