Share
Explore
Calculate repeating dates
Event
Start date
Repeat until
Repeat on these weekdays
Repeat every #
Repeat timeframe
Only use workdays
Event weekday name(s)
Upcoming event dates
Weekday name check
My first event
6/1/2022
7/13/2022
Monday
Wednesday
0
1Week(s)
MondayWednesday
6/1/20226/6/20226/8/20226/13/20226/15/20226/21/20226/22/20226/27/20226/29/20227/5/20227/6/20227/11/20227/13/2022
WednesdayMondayWednesdayMondayWednesdayTuesdayWednesdayMondayWednesdayTuesdayWednesdayMondayWednesday
My second event
6/1/2022
7/13/2022
Monday
0
1Nth Weekday of Month
Monday
6/6/20227/5/2022
MondayTuesday
There are no rows in this table
Weekday Mapper
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
Sunday
0
Monday
1
Tuesday
2
Wednesday
3
Thursday
4
Friday
5
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.
Holiday
Dates
New Year's Day
1/1/20221/1/20231/2/2023
Martin Luther King Jr. Day
1/17/20221/16/2023
Presidents' Day
2/21/20222/20/2023
Memorial Day
5/30/2022
Juneteenth
6/19/20226/20/2022
Independence Day
7/4/2022
Labor Day
9/5/2022
Indigenous Peoples' Day
10/10/2022
Veterans Day
11/11/2022
Thanksgiving Day
11/24/2022
Native American Heritage Day
11/25/2022
Christmas Eve
12/24/2022
Christmas Day
12/25/202212/26/2022
There are no rows in this table
Generate a calendar table of all repeating events
Event
Start date
Start time
End time
Repeat until
Repeat on these weekdays
Repeat every #
Repeat timeframe
Only use workdays
Create or edit events
My first event
6/1/2022
10:00 AM
11:30 AM
7/13/2022
Monday
Wednesday
0
1Week(s)
Create or edit events
My second event
6/1/2022
1:30 PM
2:00 PM
7/13/2022
Monday
0
1Nth Weekday of Month
Create or edit events
There are no rows in this table
Calendar table
Event
Date
Start
End
My first event
5/16/2022
5/16/2022, 10:00 AM
5/16/2022, 11:30 AM
My first event
5/18/2022
5/18/2022, 10:00 AM
5/18/2022, 11:30 AM
My first event
5/23/2022
5/23/2022, 10:00 AM
5/23/2022, 11:30 AM
My first event
5/25/2022
5/25/2022, 10:00 AM
5/25/2022, 11:30 AM
My first event
5/30/2022
5/30/2022, 10:00 AM
5/30/2022, 11:30 AM
My first event
6/1/2022
6/1/2022, 10:00 AM
6/1/2022, 11:30 AM
My first event
6/6/2022
6/6/2022, 10:00 AM
6/6/2022, 11:30 AM
My first event
6/8/2022
6/8/2022, 10:00 AM
6/8/2022, 11:30 AM
My first event
6/13/2022
6/13/2022, 10:00 AM
6/13/2022, 11:30 AM
My first event
6/15/2022
6/15/2022, 10:00 AM
6/15/2022, 11:30 AM
There are no rows in this table
Want to print your doc?
This is not the way.
This is not the way.
Try clicking the ⋯ next to your doc name or using a keyboard shortcut (
CtrlP
) instead.