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)


"mazalam" wrote in message
...
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....