Forum Discussion
How can I calculate anniversary date (10, 20, 30, 40, 50, and etc.) ?
See the attached file for your answer. It looks like this, using this formula copied from cell C2 to all the others. =DATE(YEAR($B2)+C$1,MONTH($B2),DAY($B2))
See the attached file for your answer. It looks like this, using this formula copied from cell C2 to all the others. =DATE(YEAR($B2)+C$1,MONTH($B2),DAY($B2))