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

--
Regards,

Peo Sjoblom

(No private emails please)


"rogerm" wrote in message
...
I would like to increase the year in a MM/DD/YYYY formated cell by 1, 2,5
and
10 and place the new dates in other cells. Adding 365 doesn't work
because
of leap years. Any suggestions?