try
=DATE(YEAR(D1)+15,MONTH(D1),DAY(D1))

--
Don Guillett
SalesAid Software

"ldavis6" wrote in 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