Annual Date Alert/Reminder
Hi. I have an employee data sheet with birth dates in one column. How can I set an annual alert that will remind me every year on the day and month their birthday falls?
As you can see above, currently at the end/beginning of every year, I search and replace the year in the Birthday column to the current/next year (now "2020") and the Alert is set to run every day and remind me at 7:00 am that it is an Employee's birthday.
Help Article Resources
Check out the Formula Handbook template!