Jim wrote on Wed, 9 Sep 2009 11:17:02 -0700:

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

"Mike H" wrote:

Hi,

=DATE(YEAR(A1)+2,MONTH(A1),DAY(A1))

Mike

"Jim" wrote:

Hello,

What formula would I use to add 24 months to a date in A1?

Thanks
Jim
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