Subtract 6 months
 

I would like to create a formula that will subtract 6 months from today's
date. What function can I use for this?

Subtract 6 months
 

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?

Subtract 6 months
 

=DATE(YEAR(TODAY()),MONTH(TODAY())-6,DAY(TODAY()))

VBA Noob


--
VBA Noob
------------------------------------------------------------------------
VBA Noob's Profile: http://www.excelforum.com/member.php...o&userid=33833
View this thread: http://www.excelforum.com/showthread...hreadid=570771

Subtract 6 months
 

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?

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?