Public Holidays Dataset

Free CSV download of national public holidays for 21 countries, 2026 and 2027.

What Happens When a Public Holiday Falls on a Weekend?

Christmas 2021 fell on a Saturday. Half the offices I knew were closed Friday the 24th, a few were closed Monday the 27th, and one confused startup gave everyone both days off and then quietly took the Monday back in January. Nobody had checked the actual rule. When a public holiday lands on a weekend, the observed date is not a matter of vibes. There are specific rules, and they differ by country and by employer.

The US federal rule

Holiday falls on Saturday → observed the preceding Friday.

Holiday falls on Sunday → observed the following Monday.

This applies to federal employees, federal offices, banks, and the markets. Private employers usually follow it too, but they are not required to. There is no federal law mandating paid holidays at all; holiday pay is a company policy, not a legal right, and hourly workers are generally paid only for hours actually worked.

Two real examples:

The "in lieu of" rules for federal workers

The Office of Personnel Management has a more precise version for federal employees on non-standard schedules. The general rule: when a holiday falls on a non-workday, the "in lieu of" holiday is the workday immediately preceding it. The exception comes from Executive Order 11582 (1971): when the holiday falls on a Sunday, the observed day is the workday immediately following. Part-time employees do not get in-lieu-of holidays at all.

This is why the simple Friday/Monday rule above works for Monday-to-Friday schedules but a federal nurse on a Wednesday-to-Saturday rotation can end up observing a different day entirely.

What it means for payroll

Three practical consequences I have seen trip up small businesses:

  1. Direct deposits move. ACH does not settle on federal holidays or weekends. If payday lands on an observed holiday, the deposit arrives the prior business day or the next one depending on the payroll provider. Run payroll a day early in holiday weeks.
  2. Salaried vs. hourly differ. Salaried exempt employees get their full weekly salary in a holiday week. Hourly employees get paid for hours worked, and any holiday premium is policy, not law.
  3. Holiday-week overtime math. A holiday counts toward the 40-hour threshold for overtime only if company policy says so. Many policies exclude it, which surprises hourly workers every Thanksgiving.

How other countries handle it

CountryWeekend holiday rule
United StatesSat → Friday before; Sun → Monday after
United KingdomSubstitute bank holiday on Monday; back-to-back weekend holidays get two substitutes
AustraliaExtra weekday holidays added (e.g. Christmas + Boxing Day weekend → additional days off)
Japan"Happy Monday" system permanently moves several holidays to Monday
New ZealandMondayisation: weekend holidays observed Monday for most
SingaporeIn-lieu day off by law for Saturday holidays

The UK approach is worth knowing if you manage anyone there. When Christmas Day 2021 fell on a Saturday, the substitute bank holiday was Monday, December 27, and Boxing Day's substitute moved to Tuesday the 28th. Two weekend holidays produced two weekday substitutes. Miss that in a leave system and your accruals are wrong for the whole year.

My advice for anyone running payroll or a team calendar

Do not hardcode observed dates from memory. Use a maintained holiday dataset that includes observed dates per country, refresh it annually, and feed it to both your leave tracker and your NETWORKDAYS formulas. The US list has 11 federal holidays; your company may add more. Either way, the list should live in one place, versioned by year.

Need observed dates by country?
Download the free public holidays CSV. 21 countries, 2026-2027, no signup.
Download the holidays CSV

FAQs

When a federal holiday falls on Saturday, which day is observed?

The preceding Friday. Federal offices, banks, and markets close on Friday. When the holiday falls on Sunday, it is observed the following Monday.

Do private employers have to give holiday pay?

No federal law requires private employers to provide paid holidays. Holiday pay and time off are company policy. Hourly employees are typically paid only for hours worked unless the policy adds a holiday premium.

What if payday falls on an observed holiday?

Direct deposits do not settle on federal holidays. Payroll must be run early so the deposit lands on a business day. Check your payroll provider's holiday schedule each year.