Help

Airtable Cobuilder is here! Learn more about our new no-code app creation feature, powered by AI on the Airtable Academy

Re: Recurring Dates Yearly

584 0
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

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?

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?