Let's say the start date is in cell A1. In another cell enter:

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

This will give the date 1 year later. You can change the +1 to +5 to make
it 5 years, etc.

Have a good day
--
Gary's Student


"rogerm" wrote:

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?