Subtract 6 months
=EDATE(TODAY(),-6)
which requires the Analysis Toolpak to be installed.
If today is 8/31/06, the other formula will return 2/31/06 which excel will
interpret as 3/3/06. I assume you would want 2/28/06?
"Lynn" wrote:
thanks - this will work!
"Thufir Howat" wrote:
Well, here is the quick and dirty.
=DATE(YEAR(TODAY()),MONTH(TODAY())-6,DAY(TODAY()))
Hopefully someone has a more elegant solution.
Lynn wrote:
I would like to create a formula that will subtract 6 months from today's
date. What function can I use for this?
|