Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Recurring Dates Yearly

Topic Labels: Dates & Timezones Formulas
1133 3
cancel
Showing results for 
Search instead for 
Did you mean: 
cyd
5 - Automation Enthusiast
5 - Automation Enthusiast

I would like the holidays to be recurring dates yearly. This is to be included in the same table as the leave tracker so that everything is in 1 calendar view only.Screenshot 2023-10-27 at 12.39.25 PM.png

3 Replies 3
Databaser
12 - Earth
12 - Earth

Isn't that tricky because your end date will vary? Do you want a fixed number of days or a certain day of the week as end date?

cyd
5 - Automation Enthusiast
5 - Automation Enthusiast

For the holidays, they will all have the same end dates. Is it possible to make them a recurring one?

Databaser
12 - Earth
12 - Earth

You could add 2 formula fields to add a year to your current start and end date, and then have an automation that triggers on the update of those fields to create a new record for the next year. 

Formula could be:

IF(TODAY()={Start Date}, DATEADD({Start Date}, 1, "year"))

 Would that be an option?