Formula for yearly anniversary with month and day only
I want to set up reminders for annual review alerts. The annual review date is a formula of Completion Date+365 days, but I don’t want to have to update the year each time. I just want to put in a completion date of 2 May 2022 and have the Anniversary column return the month and day so I can get an auto-reminder four weeks before 2 May every year. Is it possible to do what I want to do?
Help Article Resources
Check out the Formula Handbook template!