J JoeU2004 Sep 9, 2009 #3 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.
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.
J Jim Sep 9, 2009 #4 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
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
M Mike H Sep 9, 2009 #6 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
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
J James Silverton Sep 9, 2009 #7 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
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
