Share
Explore

icon picker
Repeating Dates Calculator

Make sure repeated events land on the correct weekday

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
1
My first event
6/1/2022
7/13/2022
Monday
Wednesday
0
1
Week(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
2
My second event
6/1/2022
7/13/2022
Monday
0
1
Nth 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
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.
Holiday
Dates
1
New Year's Day
1/1/20221/1/20231/2/2023
2
Martin Luther King Jr. Day
1/17/20221/16/2023
3
Presidents' Day
2/21/20222/20/2023
4
Memorial Day
5/30/2022
5
Juneteenth
6/19/20226/20/2022
6
Independence Day
7/4/2022
7
Labor Day
9/5/2022
8
Indigenous Peoples' Day
10/10/2022
9
Veterans Day
11/11/2022
10
Thanksgiving Day
11/24/2022
11
Native American Heritage Day
11/25/2022
12
Christmas Eve
12/24/2022
13
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
1
My first event
6/1/2022
​10:00 AM
​11:30 AM
7/13/2022
Monday
Wednesday
0
1
Week(s)
Create or edit events
2
My second event
6/1/2022
​1:30 PM
​2:00 PM
7/13/2022
Monday
0
1
Nth Weekday of Month
Create or edit events
There are no rows in this table
Calendar table
1
Event
Date
Start
End
1
My first event
5/16/2022
5/16/2022, 10:00 AM
5/16/2022, 11:30 AM
2
My first event
5/18/2022
5/18/2022, 10:00 AM
5/18/2022, 11:30 AM
3
My first event
5/23/2022
5/23/2022, 10:00 AM
5/23/2022, 11:30 AM
4
My first event
5/25/2022
5/25/2022, 10:00 AM
5/25/2022, 11:30 AM
5
My first event
5/30/2022
5/30/2022, 10:00 AM
5/30/2022, 11:30 AM
6
My first event
6/1/2022
6/1/2022, 10:00 AM
6/1/2022, 11:30 AM
7
My first event
6/6/2022
6/6/2022, 10:00 AM
6/6/2022, 11:30 AM
8
My first event
6/8/2022
6/8/2022, 10:00 AM
6/8/2022, 11:30 AM
9
My first event
6/13/2022
6/13/2022, 10:00 AM
6/13/2022, 11:30 AM
10
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
Calendar view
1

June 2022

Month
Today
Sunday
Monday
Tuesday
Wednesday
Thursday
Friday
Saturday
5/30/2022
6/1/2022
6/6/2022
6/8/2022
6/13/2022
6/15/2022
Want to print your doc?
This is not the way.
Try clicking the ⋯ next to your doc name or using a keyboard shortcut (
CtrlP
) instead.