Forum Discussion
louisa190
Jul 19, 2022Copper Contributor
Formula to add two years to a date?
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....
Jul 19, 2022
Hi louisa190
You would use this formula, as I am assuming your date on cell A1
=DATE(YEAR(A1)+2,MONTH(A1),DAY(A1))