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.




"Leo Heuser" wrote in message
...
Hi Carly

One way:

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

--
Best Regards
Leo Heuser

Followup to newsgroup only please.

"Carly" skrev i en meddelelse
...
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