Subtract 6 months

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I would like to create a formula that will subtract 6 months from today's
date. What function can I use for this?
 
Well, here is the quick and dirty.

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

Hopefully someone has a more elegant solution.
 
thanks - this will work!

Thufir Howat said:
Well, here is the quick and dirty.

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

Hopefully someone has a more elegant solution.
Click to expand...
 
=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?
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to subtract a number from a Mergefield? 0
Workday Formula to include date 0
Date Formula 4
Excel - Calculate age from DOB in years, months days 7
I need to add multiple cells then subtract them from one cell c4+c6+c7+c9+c10+c11 and subtract them 1
Calculate Start Date 4
need help writing a formula!!! : ) Please I need to write a formulathat will subtract .5 (half an ho 2
is there a formula that will subtract todays date from a hire date 4

Back
Top