# Recurring Dates **URL:** \ **Category:** Ask for Help\ **Created:** [December 18, 2020, 1:59pm UTC](https://community.glideapps.com/t/recurring-dates/20042 "2020-12-18T13:59:38Z")\ **Posts on this page:** 9\ **Page:** 1
**Author:** ![Andrew\_Learned](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/andrew_learned/32/67008_2.png) [@Andrew\_Learned](https://community.glideapps.com/u/Andrew_Learned)\ **Post date:** [December 18, 2020, 1:59pm UTC](https://community.glideapps.com/t/recurring-dates/20042/1 "2020-12-18T13:59:39Z")
Hey y’all, I’m a first-time poster but have been loving/learning Glide for a few months now. I have a question I’m curious about, how do y’all handle recurring events like birthdays? In a CRM app I created a calendar view of upcoming birthdays, but can’t think of an efficient way of essentially marking a date complete and essentially resetting it for the next year, or I suppose, a date-based trigger for reminders of any kind. Thanks for any help/suggestions you can provide! -Andrew ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [December 18, 2020, 3:44pm UTC](https://community.glideapps.com/t/recurring-dates/20042/2 "2020-12-18T15:44:51Z")
Hi Andrew, My approach for this in one of my old apps - specifically for the birthday part, is to have a dynamic column in my sheet to calculate when the next birthday of each person is. So let’s say I have info from user A that her birthday is on January 1, then I have a column to automatically put out the next birthday anniversary, which in this case is January 1, 2021. ---
**Author:** ![Rosewebstudio](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/rosewebstudio/32/12261_2.png) [@Rosewebstudio](https://community.glideapps.com/u/Rosewebstudio)\ **Post date:** [December 18, 2020, 3:56pm UTC](https://community.glideapps.com/t/recurring-dates/20042/3 "2020-12-18T15:56:29Z")
Hey 👋 Andrew a warm welcome to the community, great to meet you. This may also help, have a read [https://docs.glideapps.com/all/reference/data-editor/computed-columns/math-column/date-time-math](https://docs.glideapps.com/all/reference/data-editor/computed-columns/math-column/date-time-math) ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/1/1/1119fa3da3db94c41b611fa851fe396e56e8ffdb.jpeg) Wishing you success with your app. ---
**Author:** ![Andrew\_Learned](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/andrew_learned/32/67008_2.png) [@Andrew\_Learned](https://community.glideapps.com/u/Andrew_Learned)\ **Post date:** [December 18, 2020, 4:36pm UTC](https://community.glideapps.com/t/recurring-dates/20042/4 "2020-12-18T16:36:21Z")
Thank you!!! ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [December 19, 2020, 12:34am UTC](https://community.glideapps.com/t/recurring-dates/20042/5 "2020-12-19T00:34:40Z")
Here’s the arrayformula, for reference. ``` ={"Anniversary date";ARRAYFORMULA(IF(C2:C<>"",DATE(YEAR(TODAY()),MONTH(C2:C),DAY(C2:C)),""))} ``` I stored the date in column C. ---
**Author:** ![Drearystate](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/drearystate/32/49605_2.png) [@Drearystate](https://community.glideapps.com/u/Drearystate)\ **Post date:** [December 19, 2020, 4:48am UTC](https://community.glideapps.com/t/recurring-dates/20042/6 "2020-12-19T04:48:56Z")
I have it setup where one column is month and day and the other column is current year, then a combo column that combines them so I never have to check again. ---
**Author:** ![Drearystate](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/drearystate/32/49605_2.png) [@Drearystate](https://community.glideapps.com/u/Drearystate)\ **Post date:** [December 19, 2020, 4:49am UTC](https://community.glideapps.com/t/recurring-dates/20042/7 "2020-12-19T04:49:49Z")
It’s weird to see all these solutions Glide came up with after we had to build workarounds for everything. I’m not changing the old stuff…way too much work. My employee app has over 50 sheets tabs, it was created before we had glide sheets. ---
**Author:** ![Andrew\_Learned](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/andrew_learned/32/67008_2.png) [@Andrew\_Learned](https://community.glideapps.com/u/Andrew_Learned)\ **Post date:** [December 21, 2020, 9:45pm UTC](https://community.glideapps.com/t/recurring-dates/20042/8 "2020-12-21T21:45:25Z")
Thanks for this! Working like a champ now. ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [December 21, 2020, 11:50pm UTC](https://community.glideapps.com/t/recurring-dates/20042/9 "2020-12-21T23:50:48Z")
Glad to hear it worked Andrew!