Business Days Calculator
Count the working days between two dates. The calculator follows Excel's NETWORKDAYS rule: it counts both the start and end date, skips weekends, and (by default) removes observed US federal holidays that fall on a weekday in the range.
Calculate
Default result: 7
Result
Business days
How to calculate
Enter a start date and an end date. Both endpoints are counted. Leave the holiday toggle on to exclude observed US federal holidays, or turn it off to count every weekday including holidays.
businessDays = number of weekdays (Mon–Fri) from startDay to endDay inclusive, minus observed federal holidays falling on a weekday in that range (when the toggle is on). Counting is order-independent, so a reversed range gives the same total. NETWORKDAYS(d, d) = 1 on a weekday and 0 on a weekend.
Example calculation
From July 1, 2026 to July 10, 2026 there are 8 weekdays. Independence Day falls on Saturday July 4 and is observed on Friday July 3, which lands inside the range, leaving 7 business days.
- businessDays
- 7 business days
Assumptions
- Both the start and the end date are counted (inclusive). This differs from the Days Between calculator, whose default count is exclusive — so the same two dates can give a different number.
- Weekends are Saturday and Sunday.
- US federal holidays are excluded by default. They are computed for each year the range spans and shifted to the observed weekday: a holiday on Saturday is observed the Friday before, and one on Sunday the Monday after.
- A holiday that lands on a weekend has no extra effect, because that day was not a working day to begin with.
- When you open a shared link the inputs come from the URL first, then from your last-used values saved in this browser, then from the calculator's defaults.
Common mistakes
- Expecting the same number as Days Between. Business Days counts both endpoints (inclusive) while the default Days Between count is exclusive, so an inclusive count is typically one higher for the same dates.
- Forgetting that a weekday holiday is removed. With the toggle on, a federal holiday such as the observed Independence Day reduces the working-day total even though it is a Monday–Friday date.
Frequently asked questions
Are both the start and end dates counted?
Yes. Following Excel's NETWORKDAYS rule, both endpoints are included. A single weekday counted against itself is 1 business day; a single weekend day is 0.
Which holidays are excluded?
The eleven US federal holidays, shifted to their observed weekday (Saturday holidays move to the Friday before, Sunday holidays to the Monday after). Turn the toggle off to ignore holidays entirely.
Why does this differ from the Days Between calculator?
Business Days is inclusive of both endpoints and skips weekends and holidays, while Days Between counts the plain calendar difference (exclusive by default). For the same two dates the two calculators answer different questions.
Does it handle ranges that cross into the next year?
Yes. Federal holidays are computed for every year the range spans, so a span from December into January excludes the correct observed holidays on both sides.