Excel counts business days between two dates using the NETWORKDAYS function, which automatically skips Saturdays and Sundays and returns a whole number of working days inclusive of both the start and end dates. The basic syntax is =NETWORKDAYS(start_date, end_date), and you can extend it to a third argument listing holidays as date references or as an array of date values. To exclude public holidays, add a range such as =NETWORKDAYS(A1, A2, B1:B10), where B1:B10 contains your holiday list. For non-standard weekends, Excel offers NETWORKDAYS.INTL with a weekend mask argument so you can define which days of the week count as off-days. Both functions return a simple integer that you can paste directly into invoices, project plans, payroll calculations, and shipping estimates.
Spreadsheets are convenient, but they also fail in predictable ways: typos in date entries, swapped month and day formats on US versus European systems, and the wrong weekend mask for countries that observe Friday-Saturday weekends. Many users also forget that NETWORKDAYS counts the start and end days, which can inflate the result by one if you are thinking in "days between" rather than "days spanning." This guide walks through the formulas, the common pitfalls, and a faster path when you simply need a correct number right now.
What NETWORKDAYS Actually Counts
The NETWORKDAYS function (short for "network working days") returns the count of full working days between two dates, with weekend days removed. By definition it assumes a Monday-through-Friday workweek and a Saturday-Sunday weekend, mirroring the most common office schedule worldwide. The result is always an integer, and negative numbers appear when the start date is later than the end date.
If your week is unusual, NETWORKDAYS.INTL accepts a weekend mask that lets you specify any two consecutive days as the rest period. The third argument is a string or number where "0000011" means Friday and Saturday are the weekend, for example. This is how the formula accommodates work calendars in countries such as Israel, Saudi Arabia, and the UAE.
Building the NETWORKDAYS Formula Step by Step
To calculate working days between two dates, put the start date in cell A1 and the end date in cell B1. In any empty cell, type:
=NETWORKDAYS(A1, B1)
Press Enter. The cell will display the number of weekdays strictly inside that range, counting both endpoints as full days if they fall on a weekday. To add a holiday list, place your holiday dates in cells C1 through C5 and extend the formula to:
=NETWORKDAYS(A1, B1, C1:C5)
Holidays that fall on weekends are automatically ignored, so you do not need to pre-filter them. The result excludes any date appearing in the C range from the final count.
Counting Business Days in Excel: Full Procedure
- Open your workbook and identify the cells that hold the start date and end date; for this example use A1 for the start and B1 for the end.
- Make sure both cells are formatted as Date (right-click, "Format Cells," then choose the Date category) so Excel interprets them as real dates instead of text strings.
- Click an empty cell where you want the answer to appear, such as C1.
- Type =NETWORKDAYS(A1, B1) for a basic working-day count with a Saturday-Sunday weekend.
- Press Enter. The cell now shows an integer such as 21 or 44 depending on your range.
- If you have holidays to exclude, list each public holiday in a separate cell (for example D1:D10) and extend the formula to =NETWORKDAYS(A1, B1, D1:D10).
- For a non-standard weekend pattern, switch to =NETWORKDAYS.INTL(A1, B1, "0000011") where the string marks Friday and Saturday as weekend days.
- Copy the formula down the column to apply the same logic across many rows of date pairs.
Common Pitfalls and How to Avoid Them
The first trap is the inclusive boundary. Because NETWORKDAYS counts both endpoints as full working days, a Monday-to-Friday range returns 5, not 4. If your contract reads "21 business days from delivery," enter the day after delivery as the start date so the delivery day itself does not double up.
The second trap is date text masquerading as numbers. When you import dates from CSV files they sometimes arrive as text strings, and NETWORKDAYS will return a #VALUE! error. Wrap problem inputs in DATEVALUE or simply re-enter the date manually. Formatting the cell as Date before pasting often fixes this as well.
Third, holidays must be real date values, not labels. If you type "2025-12-25" into a cell formatted as General, Excel sees a piece of text and ignores it in the NETWORKDAYS holiday argument. Format the holiday list as Date first, then build the formula.
Finally, remember that NETWORKDAYS rounds in favor of completeness: even partial first or last days are counted as one. For timesheets where you need hourly granularity, switch to a custom formula or use a duration-aware Time Duration Calculator instead.
NETWORKDAYS vs NETWORKDAYS.INTL: When Each Fits
The two functions share the same structure but differ in how they define the weekend. Choosing the right one matters as soon as your team, customer, or supplier follows a non-Western calendar.
| Scenario | Recommended Function | Extra Argument |
|---|---|---|
| Standard Mon-Fri office in the US, UK, EU, or Australia | NETWORKDAYS | None required |
| Middle East team observing Friday-Saturday weekend | NETWORKDAYS.INTL | "0000011" or 7 |
| Nepal or Iran with a single weekly rest day | NETWORKDAYS.INTL | "1000000" or 11 |
| Need to exclude public holidays in addition to weekends | Either function | Append holiday range as 3rd argument |
| US federal holidays are aligned to specific weekdays | Either function | List as date references, e.g. C1:C11 |
Calculating Business Days Past a Deadline
Sometimes the question is reversed: how many working days have passed since a fixed point in history? Excel handles this gracefully. If your start date is in the past and the end date is in the future or present, NETWORKDAYS still returns a positive integer representing the count of weekdays in between. For "days since" calculations where one anchor date is fixed, this is faster than subtracting two date cells and dividing by seven.
You can also use =NETWORKDAYS(A1, TODAY()) to keep a rolling counter: as the workbook recalculates each day, the cell updates with the latest running tally. Combine this with conditional formatting to flag invoices that have crossed a 30-day payment threshold.
Doing the Same Calculation in Your Browser
The fastest path when you don't want to set up a sheet, format columns, or remember which mask string matches Friday-Saturday, is the Business Days Calculator. Open the tool, pick your start and end dates, and the working-day count, total days, and weekend days update instantly without pressing a button. You can also paste a comma-separated list of holidays in YYYY-MM-DD format if you want to subtract specific public holidays from the working total.
This is especially useful for one-off checks where setting up an Excel sheet would be overkill: a single invoice due date, a short sprint, a project handover window, or a vendor onboarding deadline. Because the result is computed in the browser and nothing is uploaded, you can paste sensitive dates without compliance concerns. For more elaborate scenarios involving multiple date pairs or recurring ranges, you may still prefer Excel so you can store historical results.
Working Day Counts for Planning and Billing
Project managers rely on working-day counts for sprint sizing, milestone tracking, and resource allocation. A two-week sprint framed in business days is typically ten working days when holidays are excluded, which is why teams track capacity rather than elapsed calendar days. Billing and contract teams use similar math for service-level agreements, where missing a deadline by one business day can trigger a penalty or a credit.
For deeper planning, pair the business-day count with a Date Difference Calculator to compare business days against total elapsed days in the same view. If you need to step forward by N working days (rather than count between two dates), the related how-to guide on counting business days between two dates covers the WORKDAY function in detail.
Validation Checklist Before Quoting a Number
- Confirm both date cells display as dates, not as number serial values.
- Confirm the working week matches your locale (Sat-Sun vs Fri-Sat).
- Confirm holidays are in the third argument, formatted as dates.
- Confirm inclusive versus exclusive endpoint convention for your specific use case.
- Confirm no blank cells are hiding inside the holiday range, since blanks are treated as zero (1900) by Excel.
After running through this list, your NETWORKDAYS output is reliable for invoicing, payroll, SLA tracking, and most general project planning. For ad-hoc questions or when the recipient expects a number without opening a spreadsheet, the Business Days Calculator gives you a verified working-day count in a single click.