Auto calculate end date

Q

QPapillon

Good Day,

I have a column with start dates and I want to have the column beside it
display 5 years forward, e.g.: column A: 2008-05-11 , column B: 2013-05-11

How can I do this automatically?

Thanks!
Carol
 
L

Lars-Åke Aspelin

Good Day,

I have a column with start dates and I want to have the column beside it
display 5 years forward, e.g.: column A: 2008-05-11 , column B: 2013-05-11

How can I do this automatically?

Thanks!
Carol
Click to expand...


It you don't mind 2008-02-29 and 2008-03-01 to result in the same date
"5 years forward", then you can try the following formula

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

Hope this helps / Lars-Åke
 
Q

QPapillon

Thank you! -C.

Lars-Ã…ke Aspelin said:
It you don't mind 2008-02-29 and 2008-03-01 to result in the same date
"5 years forward", then you can try the following formula

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

Hope this helps / Lars-Ã…ke
Click to expand...
 
Top