Formula to add two years to a date?

Question

Hi all,&nbsp;&nbsp;I have a spreadsheet with hundreds of dates in them and i need to add two years to them, so for example 19/07/2022 i would like the formula to add two years to it so it reads 19/07/2024.&nbsp;I have tried several formulas but changes the date to the 1970's lol.&nbsp;&nbsp;Any help i would appreciate&nbsp;

jihad al-jarady · Answer

Hi&nbsp;louisa190&nbsp;You would use this formula, as I am assuming your date on cell A1=DATE(YEAR(A1)+2,MONTH(A1),DAY(A1))&nbsp;&nbsp;

sergeibaklan · Answer

louisa190&nbsp;
As variant
=EDATE(A1,24)
If necessary apply date format to the target cell.

Forum Discussion

Formula to add two years to a date?

2 Replies

Resources