Adding 40 years to date

[Jaydeebug]

In column 'A' I have a date that an event occurred. In Column 'B' I need to
show that date 40 years later. i.e 06/25/2008 in column 'A' needs to be
06/25/2048 in column 'B'. I have a huge number of entries so it is not
convenient to manually enter the new date. Is there a formula for this?

 

[T. Valko]

Try this:

A1 = some date

=DATE(YEAR(A5)+40,MONTH(A5),DAY(A5))

 

[Jaydeebug]

Thank you for your help

Try this:

A1 = some date

=DATE(YEAR(A5)+40,MONTH(A5),DAY(A5))

 

[T. Valko]

You're welcome!

--
Biff
Microsoft Excel MVP

Thank you for your help