Repeat automation every year on date in date field
Options
Shane Brown
✭✭✭
I have a sheet with people's birthdays listed. The dates (kind of under the formatting) are stored as mm/dd/yyyy. What I want is an automation that reminds me when it's someone's birthday every year. Is there a way to use only the mm/dd date in the field for the automation to reference?
Comments
-
You could add another date type column with a formula to output their next birthday. Then on the day after their birthday, it will automatically change to the next one.
=DATE(YEAR(TODAY()) + IF(TODAY() > DATE(YEAR(TODAY()), MONTH([Date of Birth]@row), DAY([Date of Birth]@row)), 1, 0), MONTH([Date of Birth]@row), DAY([Date of Birth]@row))
Then you can set up an automation to trigger on this new date field to set a reminder.
