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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel does not accept text format! 0
Lookup in multiple & separate cells 6
If formula producing #VALUE Error 2
Default IF Date Is between 2 Dates then output additional column 1
Show value from one cell in another cell if today falls between a date range 5
Need Help with a VBA subroutine 0
Allocate an income payment over a date range (tax years) 7
Merging from an Excel file with graphics 1

Top