Adding 5 yrs to a date

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

Guest

How can I add 5 yrs to an existing date using a formula?

Current Date Desired Date
09/25/2007 09/25/2012


Thanks for your time....
 
With
A1: (current date)

This formula won't get tripped up by a 29-Feb (leap year) start date:
=MIN(DATE(YEAR(A1)+5,MONTH(A1)+{0,1},DAY(A1)*{1,0}))

If today is 29-Feb-2000,
the formula returns: 28-Feb-2005
--------------------------

Regards,

Ron (XL2003, Win XP)
Microsoft MVP (Excel)
 
Back
Top