one way:

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


In article ,
"ldavis6" wrote:

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