Add 24mo to a date

  • Thread starter Thread starter Jim
  • Start date Start date
Jim said:
What formula would I use to add 24 months to a date in A1?
Click to expand...

That depends on what you expect for 2/29/2008: 2/28/2010 or 3/1/2010?

=EDATE(A1,24)

will result in 2/28/2010. If you get a #NAME error, read the help page for
EDATE.
 
This is perfect. I have two more questions if oyu have a moment.

How do I write this formula to show (blank) if A1 is empty?

And

Can you help me with a formula that will poulate an X if the date in A1 is
3mo or less. X showing in B1.

Thanks
Jim
 
Luke has answered the part about the cell being blank. You will have to
clarify what you mean by
Can you help me with a formula that will poulate an X if the date in A1 is
3mo or less. X showing in B1
Click to expand...

3 months or less then what?

Mike
 
Jim wrote on Wed, 9 Sep 2009 11:17:02 -0700:
How do I write this formula to show (blank) if A1 is empty?

Can you help me with a formula that will poulate an X if the
date in A1 is 3mo or less. X showing in B1.

"Mike H" wrote:
Click to expand...
Isn't there a little problem with leap years and
=DATE(YEAR(A1)+2,MONTH(A1),DAY(A1))

2/28/2008 2/28/2010
2/29/2008 3/1/2010
3/1/2008 3/1/2010
3/2/2008 3/2/2010


--

James Silverton
Potomac, Maryland

Email, with obvious alterations: not.jim.silverton.at.verizon.not
 
Back
Top