Formula to add two years to a date?

Occasional Visitor

Hi all, 


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.


I have tried several formulas but changes the date to the 1970's lol. 


Any help i would appreciate 

2 Replies

Hi @louisa190 

You would use this formula, as I am assuming your date on cell A1





As variant


If necessary apply date format to the target cell.