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

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

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

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

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

where A1 holds the end date, copy down

Regards,

Peo Sjoblom

"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

=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


.