Skip to content
Gallery
Coda Template USA Holidays
Share
Explore

icon picker
DB Holidays

Table you can use as source table

An automation generates for you holidays and observation days

New Year’s Day | 1st of the Year
Memorial Day | Last Monday of May
Independence Day | July 4th
Labor Day | First Monday of September
Thanksgiving Day | 4th Thursday of November
Christmas Eve | December 24th
Christmas Day | December 25th

Generate Obseved dates for 2024 - 2025

DB Holidays
Name
holidayType
theNextDate
theWeekday
TheObservedDay
GenerateObservedDay
i
theNextDates
i
thePreviousDates
i
1
Thanksgiving Day
Variable Dates
11/24/2022
Thursday
11/24/2022
generate observation date
11/25/202211/28/202211/29/202211/30/202212/1/2022
11/23/202211/22/202211/21/202211/18/202211/17/2022
2
Observed Christmas Eve
Observed Day
12/23/2022
Friday
12/23/2022
generate observation date
12/27/202212/28/202212/29/202212/30/2022
12/22/202212/21/202212/20/202212/19/202212/16/2022
3
Christmas Eve
Fixed Dates
12/24/2022
Saturday
create observed day
generate observation date
12/27/202212/28/202212/29/202212/30/2022
12/22/202212/21/202212/20/202212/19/2022
4
Christmas Day
Fixed Dates
12/25/2022
Sunday
create observed day
generate observation date
12/27/202212/28/202212/29/202212/30/2022
12/22/202212/21/202212/20/202212/19/2022
5
Observed Christmas Day
Observed Day
12/26/2022
Monday
12/26/2022
generate observation date
12/27/202212/28/202212/29/202212/30/2022
12/22/202212/21/202212/20/202212/19/2022
6
New Year’s Day
Fixed Dates
1/1/2023
Sunday
create observed day
generate observation date
1/3/20231/4/20231/5/20231/6/2023
12/30/202212/29/202212/28/202212/27/2022
7
Observed New Year’s Day
Observed Day
1/2/2023
Monday
1/2/2023
generate observation date
1/3/20231/4/20231/5/20231/6/20231/9/2023
12/30/202212/29/202212/28/202212/27/2022
8
Memorial Day
Variable Dates
5/29/2023
Monday
5/29/2023
generate observation date
5/30/20235/31/20236/1/20236/2/20236/5/2023
5/26/20235/25/20235/24/20235/23/20235/22/2023
9
Independence Day
Fixed Dates
7/4/2023
Tuesday
07/04/2023
generate observation date
7/5/20237/6/20237/7/20237/10/20237/11/2023
7/3/20236/30/20236/29/20236/28/20236/27/2023
10
Labor Day
Variable Dates
9/4/2023
Monday
9/4/2023
generate observation date
9/5/20239/6/20239/7/20239/8/20239/11/2023
9/1/20238/31/20238/30/20238/29/20238/28/2023
11
Memorial Day
Variable Dates
5/27/2024
Monday
5/27/2024
generate observation date
5/29/20245/30/20245/31/20246/3/2024
5/24/20245/23/20245/22/20245/21/20245/20/2024
12
Memorial Day
Variable Dates
5/28/2024
Tuesday
5/28/2024
generate observation date
5/29/20245/30/20245/31/20246/3/20246/4/2024
5/24/20245/23/20245/22/20245/21/2024
13
Independence Day
Fixed Dates
7/4/2024
Thursday
7/4/2024
generate observation date
7/5/20247/8/20247/9/20247/10/20247/11/2024
7/3/20247/2/20247/1/20246/28/20246/27/2024
14
Labor Day
Variable Dates
9/2/2024
Monday
9/2/2024
generate observation date
9/4/20249/5/20249/6/20249/9/2024
8/30/20248/29/20248/28/20248/27/20248/26/2024
15
Labor Day
Variable Dates
9/3/2024
Tuesday
9/3/2024
generate observation date
9/4/20249/5/20249/6/20249/9/20249/10/2024
8/30/20248/29/20248/28/20248/27/2024
16
Thanksgiving Day
Variable Dates
11/22/2024
Friday
11/22/2024
generate observation date
11/25/202411/26/202411/27/202411/29/2024
11/21/202411/20/202411/19/202411/18/202411/15/2024
17
Thanksgiving Day
Variable Dates
11/28/2024
Thursday
11/28/2024
generate observation date
11/29/202412/2/202412/3/202412/4/202412/5/2024
11/27/202411/26/202411/25/202411/21/2024
18
Christmas Eve
Fixed Dates
12/24/2024
Tuesday
12/24/2024
generate observation date
12/26/202412/27/202412/30/202412/31/2024
12/23/202412/20/202412/19/202412/18/202412/17/2024
19
Christmas Day
Fixed Dates
12/25/2024
Wednesday
12/25/2024
generate observation date
12/26/202412/27/202412/30/202412/31/2024
12/23/202412/20/202412/19/202412/18/2024
20
New Year’s Day
Fixed Dates
1/1/2025
Wednesday
01/01/2025
generate observation date
1/2/20251/3/20251/6/20251/7/20251/8/2025
12/31/202412/30/202412/27/202412/26/2024
21
Memorial Day
Variable Dates
5/26/2025
Monday
5/26/2025
generate observation date
5/27/20255/28/20255/29/20255/30/20256/2/2025
5/23/20255/22/20255/21/20255/20/20255/19/2025
22
Independence Day
Fixed Dates
7/4/2025
Friday
07/04/2025
generate observation date
7/7/20257/8/20257/9/20257/10/20257/11/2025
7/3/20257/2/20257/1/20256/30/20256/27/2025
23
Labor Day
Variable Dates
9/1/2025
Monday
9/1/2025
generate observation date
9/2/20259/3/20259/4/20259/5/20259/8/2025
8/29/20258/28/20258/27/20258/26/20258/25/2025
24
Thanksgiving Day
Variable Dates
11/27/2025
Thursday
11/27/2025
generate observation date
11/28/202512/1/202512/2/202512/3/202512/4/2025
11/26/202511/25/202511/24/202511/21/202511/20/2025
There are no rows in this table



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.