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

=DATE(YEAR(A1)+2,MONTH(A1),DAY(A1))

 

 

@louisa190 

As variant

=EDATE(A1,24)

If necessary apply date format to the target cell.