Share
Explore

icon picker
Repeating Dates Calculator

Make sure repeated events land on the correct weekday
Ben Lee

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
29
30
31
01
02
03
04
5/30/2022
6/1/2022
05
06
07
08
09
10
11
6/6/2022
6/8/2022
12
13
14
15
16
17
18
6/13/2022
6/15/2022
19
20
21
22
23
24
25
26
27
28
29
30
01
02
⁠
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.