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
|