formula to calculate expiration date: last day of third succeeding calendar year

[hrachao]

Hi,

Can someone help with this one? Based on an initial date, need to calculate 3 years later end of year.

Example:

Expiration date is the last day of the third succeeding calendar year
Initial date: 19/09/2018
End date: 31/12/2021

Thanks!
Helena

 

[steve the fish]

Hi. Try:

=DATE(YEAR(A1)+3,12,31)

with initial date in A1.

 

[hrachao]

Hi. Try:

=DATE(YEAR(A1)+3,12,31)

with initial date in A1.

works!
thanks