How do I set up a date cell to and 15 years in another cell?

L

ldavis6

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
 
P

Peo Sjoblom

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

where A1 holds the end date, copy down

Regards,

Peo Sjoblom
 
Top