Forum Discussion
lisahex77
Jan 15, 2022Copper Contributor
formulas
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 s...
Juliano-Petrukio
Jan 15, 2022Bronze Contributor
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)