Adding 40 years to date
 

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?

Adding 40 years to date
 

Try this:

A1 = some date

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

--
Biff
Microsoft Excel MVP


"Jaydeebug" wrote in message
...
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?

Adding 40 years to date
 

Thank you for your help

"T. Valko" wrote:

Try this:

A1 = some date

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

--
Biff
Microsoft Excel MVP


"Jaydeebug" wrote in message
...
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?

Adding 40 years to date
 

You're welcome!

--
Biff
Microsoft Excel MVP


"Jaydeebug" wrote in message
...
Thank you for your help

"T. Valko" wrote:

Try this:

A1 = some date

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

--
Biff
Microsoft Excel MVP


"Jaydeebug" wrote in message
...
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?