Skip to content
New Year’s Day | 1st of the YearMemorial Day | Last Monday of MayIndependence Day | July 4thLabor Day | First Monday of SeptemberThanksgiving Day | 4th Thursday of NovemberChristmas Eve | December 24thChristmas Day | December 25th
iii
DB Holidays
Table you can use as source table
An automation generates for you holidays and observation days
Generate Obseved dates for 2026 - 2027
DB Holidays
Name
holidayType
theNextDate
theWeekday
TheObservedDay
GenerateObservedDay
theNextDates
thePreviousDates
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
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
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
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
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
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
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
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
Independence Day
Fixed Dates
7/4/2023
Tuesday
7/4/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
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
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
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 ··· in the right corner or using a keyboard shortcut (
CtrlP
) instead.