If you keep a spreadsheet of deadlines, leave or delivery dates, you will eventually need to calculate business days in Excel rather than by counting on a calendar. Excel has a purpose-built function for exactly this: NETWORKDAYS. It counts the Monday to Friday days between two dates, and with one extra argument it removes holidays as well. This guide walks through the formula, two worked examples with real dates, and the one behavior of NETWORKDAYS that surprises almost everyone the first time - it counts both of your dates.
The NETWORKDAYS formula
The syntax is =NETWORKDAYS(start_date, end_date, [holidays]). The first two arguments are required; the third is an optional range of holiday dates to exclude. A typical setup:
| Cell | Contents | Meaning |
|---|---|---|
| A2 | 2026-03-06 | Start date |
| B2 | 2026-03-20 | End date |
| C2 | =NETWORKDAYS(A2,B2) | Business days between the dates, weekends removed |
| C3 | =NETWORKDAYS(A2,B2,$E$2:$E$12) | Same count, with the holiday list in E2:E12 also removed |
Build the holiday list once, in a spare column or a separate sheet, and reference it with absolute references (the dollar signs) so you can copy the formula down a column without the range drifting. Type each holiday as a real Excel date. For a United States list, use the 11 federal holidays on their observed dates - in 2026 that means Friday, July 3 for Independence Day, not Saturday, July 4, because the observed weekday is the day that actually needs removing.
Worked example 1: a two-week span with no holidays
From Friday, March 6 to Friday, March 20, 2026, =NETWORKDAYS(A2,B2) returns 11. Count them: March 6, then 9, 10, 11, 12, 13, then 16, 17, 18, 19 and 20 - eleven Monday to Friday days, because the formula counts both the start date and the end date.
Compare that with the deadline method from our guide on counting business days for a deadline, where the same two dates produce 10: a deadline count never includes the start day. Neither answer is wrong. NETWORKDAYS answers "how many workdays are inside this period, both ends included?" while a deadline count answers "how many business days pass after this event?" Know which question you are asking. If you need the deadline answer from NETWORKDAYS, subtract 1 - or enter the day after the event as your start date.

Worked example 2: adding the holiday list
Now take Monday, January 5 to Monday, January 19, 2026. Without the third argument, NETWORKDAYS returns 11 - the eleven weekdays in the span, both ends counted. But January 19, 2026 is Martin Luther King Jr. Day, a federal holiday. Add a holiday range containing that date and the same formula returns 10. One cell in a list changed the answer by a day, which is exactly why the holiday argument is not optional decoration: any span that crosses a holiday is wrong without it.
A practical habit: keep one named holiday list per year, and update it every January. The most common spreadsheet error I see is not a broken formula - it is a perfect formula still pointing at last year's holidays. If you would rather not maintain the list at all, the business days calculator carries the current federal list for you, and the homepage calculator shows the holiday-adjusted figure for any pair of dates.
Adding business days instead of counting them
The companion function is WORKDAY: =WORKDAY(start_date, days, [holidays]) returns the date a given number of business days after the start. Unlike NETWORKDAYS, WORKDAY does not count the start date, so it matches deadline logic directly. =WORKDAY(DATE(2026,6,10),7,Holidays) returns Monday, June 22, 2026: the count runs June 11, 12, 15, 16, 17 and 18, skips Juneteenth on Friday, June 19, and lands on the 22nd as the seventh business day. Leave the holiday list out and the same formula returns June 19 itself - a date your office is closed. WORKDAY with a negative number of days counts backwards, which is how you find the latest start date for a fixed deadline.
When NETWORKDAYS is the wrong function
NETWORKDAYS hard-codes Saturday and Sunday as the weekend. If your weekend is different - a Friday-Saturday weekend, a single day off, or a rotating pattern - you need NETWORKDAYS.INTL, which takes a weekend code or a seven-character string. Our separate guide on NETWORKDAYS.INTL and custom weekends covers the codes. NETWORKDAYS also counts whole days only; it cannot handle business hours or half days. For those, count the days with NETWORKDAYS and handle the part-days separately, the way our guide on half days explains.
Troubleshooting: the three errors everyone meets
A negative answer means your end date is earlier than your start date. NETWORKDAYS reports this honestly as a negative count rather than an error, which makes it useful for measuring how far behind a schedule has slipped - but if you expected a positive number, check for a transposed date. A result that is too high by several days usually means the holiday argument is missing, or the holiday range contains text that merely looks like dates (a common result of importing a CSV). Real dates right-align in their cells and can be reformatted; text cannot. A #VALUE! error means one of the date arguments is not a date at all - often a date typed with a period or an extra space. Fix the cell, not the formula. Finally, if your count is exactly one more than the deadline count a colleague produced by hand, neither of you is wrong: you are seeing the inclusive-endpoints behavior described above, and the fix is to agree on which question the spreadsheet is answering before you change anything.
Frequently asked questions
What is the Excel formula for business days between two dates?
Use =NETWORKDAYS(start_date, end_date, holidays). Put the start date in one cell and the end date in another, for example =NETWORKDAYS(A2,B2), and add a range of holiday dates as the third argument to remove those too.
Does NETWORKDAYS count the start and end dates?
Yes. NETWORKDAYS counts both the start date and the end date when they fall on workdays. That is different from deadline counting, which never counts the start day, so the two methods often differ by exactly one.
Why is my NETWORKDAYS result one more than expected?
Almost always because NETWORKDAYS is inclusive of both endpoints. If you need the deadline-style count, subtract 1, or start from the day after your start date. Check also that your holiday list contains real dates and not text that merely looks like dates.
How do I add business days to a date in Excel?
Use WORKDAY. =WORKDAY(start_date, days, holidays) returns the date that is the given number of business days after the start date, skipping weekends and any holidays you list. It does not count the start date itself.
Can NETWORKDAYS handle a weekend that is not Saturday and Sunday?
No - NETWORKDAYS always treats Saturday and Sunday as the weekend. For any other weekend pattern, use NETWORKDAYS.INTL, which lets you pick the weekend days or define them with a seven-character string.
