Auto calculate end date

[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

 

[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

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

 

[Teethless mama]

=EDATE(A1,60)

 

[QPapillon]

Thank you! -C.

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

 

[QPapillon]

Thanks! -C.

=EDATE(A1,60)