I agree - It is very powerful - why isn't part of the standard functions -
is this due to the historical versions when the add-in was first developed?

"Duke Carey" wrote in message
...
Carly -

The Analysis Toolpak is standard with Excel. Go to ToolsAdd-ins and check
it to isntall it. It gives you access to quite a variety of powerful
functions & is well woorth while.


"Carly" wrote:

Thanks Duke. That one would be perfect, but I don't have the Analysis
Toolpak
:(

Any ideas of a work around?
--
Carly


"Duke Carey" wrote:

With the Analysis Toolpak add-in installed use

=edate(a1,-3)


"Carly" wrote:

Hiya, I have a date in cell A1 and I want to know a formula which will
calculate this date minus 3 months, in cell A2.

I've tried a simple "=A1-3month" but this doesn't work.

Any ideas?
--
Carly