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
|