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

HTH
Jason
Atlanta, GA

-----Original Message-----
I have an end date for a Grant in one cell and the next
cell Needs to have 15
years automatically added for a destruction date. All
the way down a
spreadsheet.

Thanks


.