Case Statement and DateADD

[PierreT]

Hello,

I have 3 Columns and multiple rows. Columns E, F and G.

When I enter the numeric value "2" in column E, I would like it to add 10 years to the date that is already written in column F and have it display in column G
When I enter the numeric value "3" in column E, I would like it to add 5 years to the date that is already written in column F and have it display in column G

Example:

E F G
2 1900 1910
3 1900 1905
2 1972 1982
2 2013 2023
3 1475 1480

Not sure how. If you could explain the code as well it would be much appreciated.

Thanks

 

[Jonmo1]

In G2 you could put

=EDATE(F2,12*IF(E2=2,10,IF(E2=3,5,0)))

 

[PierreT]

thanks, works like a charm.

 

[Jonmo1]

You're welcome.