Formula: Date plus 3 months

[Guest]

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?

 

[Leo Heuser]

Hi Carly

One way:

=DATE(YEAR(A1),MONTH(A1)-3,DAY(A1))

 

[Guest]

With the Analysis Toolpak add-in installed use

=edate(a1,-3)

 

[Guest]

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


Any ideas of a work around?

 

[Guest]

Thats done the trick; many thanks Leo!
--
Carly

Hi Carly

One way:

=DATE(YEAR(A1),MONTH(A1)-3,DAY(A1))

--
Best Regards
Leo Heuser

Followup to newsgroup only please.

 

[Guest]

Carly -

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

 

[Andibevan]

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?

Carly -

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

 

[Leo Heuser]

You're welcome, Carly, and thanks for the feedback

LeoH

 

[PC]

Date functions in XL are a bit problematic.

With May 31, 2005 in A1 and with

=DATE(YEAR(A1),MONTH(A1)-3,DAY(A1))

in B1 the return date is March 3, 2005

I don't think that's what the OP really wants.

Using the edate from the analysis toolpack as someone else suggested may be
better.