formulas

Occasional Visitor

need a formula to find out remaining years, so if i have todays date and an amount of years and months i then need to know what the date would be if i added the years onto the date but i need it to show me tha answer in date for so for example:-

 

15/01/2022 + 12 years  8 months = dd/mm/yy

 

What would the formula be.

2 Replies

@lisahex77 

The easiest way is by converting years to months and use the EDATE() formula.

=EDATE(InitialDate;Years*12+Months)

Find attachement

=EDATE(A2,B2*12+C2)

JulianoPetrukio_0-1642272023387.png

 

@lisahex77 

That could be like

image.png