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


"Leo Heuser" wrote:

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