We use the following Weekday Mapper table to allow for an easy dropdown option to choose days of the week for an event to repeat as well as assign a value per day that’s used in the Calculated dates column formula in the table above.
Day
Value
Day
Value
1
Sunday
0
2
Monday
1
3
Tuesday
2
4
Wednesday
3
5
Thursday
4
6
Friday
5
7
Saturday
6
There are no rows in this table
Holidays - only use workdays
A Holidays table can be used to create a list of additional days to exclude as non-working days when the Only use workdays toggle is enabled. In this case, the date used will bump to the next working day. If you have an event that repeats on Monday, but an upcoming Monday is a holiday, that event will be scheduled for Tuesday.