Removing weekends is the easy half of a business day count. The half that quietly breaks deadlines is the holidays: a span can contain eleven weekdays and still hold only nine days when anyone is actually at work. Learning how to exclude holidays from a business day count - deliberately, with the right list, on the right dates - is what separates a count you can defend from a count you hope is right. This guide covers the method by hand, in a spreadsheet, and with a calculator, plus the observed-date trap that catches most people.
Step 1: choose the right holiday list
There is no universal holiday list, so the first step is deciding whose holidays you are removing. For anything touching US banks, federal courts or federal agencies, the answer is the 11 federal holidays: New Year's Day, Martin Luther King Jr. Day, Washington's Birthday, Memorial Day, Juneteenth, Independence Day, Labor Day, Columbus Day, Veterans Day, Thanksgiving and Christmas Day. State courts and state agencies may add state holidays. A private contract may name its own list. Your own company may close on extra days - the day after Thanksgiving and the stretch between Christmas and New Year are the usual ones.
The rule of thumb: the list belongs to the institution that has to act on the deadline. If a bank must process something, the bank's holidays govern, even if your office is open. Our business days calculator starts with the federal list and lets you add your own days off, which mirrors how most real counts work. The homepage calculator shows the federal-holiday figure alongside the plain weekday figure for any span.
Step 2: use observed dates, not calendar dates
This is the step almost everyone misses. Federal holidays are taken on observed dates: when the holiday falls on a Saturday, the day off moves back to Friday; when it falls on a Sunday, it moves forward to Monday. In 2026, Independence Day falls on Saturday, July 4, so the federal holiday is Friday, July 3. If your list says July 4, your count for that week is wrong in the worst way - it removes a Saturday that was never counted, and leaves a closed Friday in.
The same shift applies in 2027 three times: Juneteenth (Saturday, June 19) is observed on Friday, June 18; Independence Day (Sunday, July 4) on Monday, July 5; and Christmas Day (Saturday, December 25) on Friday, December 24. Any list you build should store the observed weekday, because that is the day offices actually close.

Step 3: the count itself, worked by hand
Take the span from Monday, December 21 to Thursday, December 31, 2026, counting the days after the start date. The weekdays in the span are December 22, 23, 24, 25, 28, 29, 30 and 31 - eight weekdays. Now scan the holiday list: Christmas Day, Friday, December 25, sits inside the span on a weekday. Remove it, and the count is 7 business days. That is the whole method: count the weekdays, then subtract each listed holiday that falls on a weekday inside the span. Holidays that fall on weekends subtract nothing, because they were never in the weekday count to begin with.
Two edges to watch. If your span crosses a year boundary, you need both years' lists - late December spans routinely reach into January, where New Year's Day is waiting. And if the deadline day itself is a holiday, most rules roll the deadline forward to the next business day rather than simply removing the day, because the act (filing, paying, delivering) cannot happen at a closed office.
The same count in a spreadsheet
In Excel or Google Sheets, the holiday list does the work for you. Put each observed holiday in its own cell as a real date, then pass the range to the function: =NETWORKDAYS(A2,B2,Holidays). The function removes any listed date that falls on a weekday inside the span and ignores the rest, which is why observed dates matter so much - a listed Saturday changes nothing, and an unlisted observed Friday changes everything. Our guides on NETWORKDAYS in Excel and business days in Google Sheets build this out with full examples, and the INTL guide covers lists for other countries' weekends.
Keeping the list honest over time
A holiday list is only right for the year it was built. Rebuild it every January, checking three things: the observed dates for the fixed-date holidays (January 1, June 19, July 4, November 11, December 25), the Monday and Thursday holidays whose dates move (Thanksgiving is always the fourth Thursday of November - November 26 in 2026, November 25 in 2027), and any company days your employer has added or dropped. Ten minutes once a year is cheap insurance against the most common counting error there is. If you would rather not maintain a list at all, run the count in the business days calculator, which carries the federal list on its observed dates and updates with the calendar.
Frequently asked questions
Which holidays should I exclude from a business day count?
Exclude the holidays observed by the institution you are counting for. For US banks, courts and federal deadlines, that is the 11 federal holidays on their observed dates. For a private contract, use the holiday list the contract names; if it names none, the federal list is the standard default.
Do I exclude a holiday that falls on a weekend?
Not on the weekend day itself, because it was never a business day anyway. But watch the observed shift: a Saturday holiday is usually observed on the Friday before, and a Sunday holiday on the Monday after, and those weekdays do need to be excluded.
What if a holiday falls on my start or end date?
If a holiday falls inside the span on a weekday, it is removed like any other. If your end date is itself a holiday, a deadline normally rolls forward to the next business day, because the office you must reach is closed on the day itself.
Should company shutdown days count as holidays?
For internal counts, yes - a day the whole office is closed is not a working day, whatever the calendar calls it. Many companies close between Christmas and New Year or on the day after Thanksgiving. Add those dates to your list, but say so when you report the count.
How do I exclude holidays in Excel?
Pass a range of holiday dates as the third argument of NETWORKDAYS, or the fourth argument of NETWORKDAYS.INTL. List each holiday as a real date in its own cell, using observed dates, and the function removes any that fall on weekdays inside your span.
