Counting business days from a date in Excel is what the NETWORKDAYS function does: it returns the number of whole weekdays between a start date and an end date, treats Monday through Friday as working days, automatically skips Saturday and Sunday, and optionally subtracts a list of holidays you feed it. The basic syntax is =NETWORKDAYS(start_date, end_date, [holidays]) and the result is inclusive of both endpoints, so a Monday-to-Friday range inside the same week returns 5, not 4, matching how most people count workdays for payroll, deadlines, and shipping windows. If you want to add business days to a date rather than count them between two dates, use WORKDAY or WORKDAY.INTL instead; both apply the same weekend rule and the same holiday list. NETWORKDAYS has shipped with Excel since 2007 and behaves identically in Excel for Microsoft 365, Excel 2021, Excel 2019, and older desktop releases. The variant NETWORKDAYS.INTL exists for organizations whose weekend is not Saturday-Sunday, but the standard NETWORKDAYS is the right tool for the Mon-Fri convention. For a quick sanity check, a free browser-side Business Days Calculator mirrors the same inclusive weekday count and shows the total calendar days, weekend days, and excluded holidays right next to the working-day total.
What "Business Days from a Date" Actually Means
A business day is any weekday on which work normally happens: Monday, Tuesday, Wednesday, Thursday, or Friday. The phrase "business days from a date" can mean two slightly different things, and choosing the right idea matters before you touch a formula. The first meaning is "count how many business days fall between a start date and an end date," which is the NETWORKDAYS job. The second meaning is "starting from a date, add N business days and land on a working day," which is the WORKDAY job. Payroll, project deadlines, and SLA turnaround times are usually the first kind; contract notice periods, shipping cutoffs, and onboarding start dates are usually the second kind. Both jobs share the same weekend rule (Saturday and Sunday are excluded) and the same holiday treatment (a holiday on a weekday is removed, a holiday on a weekend is ignored). Once you know which direction you need, the choice of function becomes straightforward.
NETWORKDAYS and WORKDAY in Excel Step by Step
Excel handles both meanings of "business days from a date" with two well-documented functions. Follow these steps for the count-between-two-dates case, which is the most common.
- Type the start date into a cell, for example A2, and the end date into B2. Make sure both cells are formatted as dates (Home > Number > Short Date).
- Click an empty cell and enter =NETWORKDAYS(A2, B2). Press Enter and Excel returns the number of weekdays between the two dates, inclusive of both endpoints.
- To exclude public holidays, list them in a column (for example D2:D10) and use =NETWORKDAYS(A2, B2, D2:D10). Excel subtracts each listed holiday that falls inside the range and lands on a weekday.
- If you selected the dates with the mouse, wrap the arguments in DATEVALUE or DATE to be safe: =NETWORKDAYS(DATE(2024,1,1), DATE(2024,1,15)).
- To add business days to a single date instead, use =WORKDAY(A2, 10) where 10 is the number of working days to add. The result is a date that lands on a weekday after 10 weekdays have passed.
- For a custom weekend, swap in NETWORKDAYS.INTL or WORKDAY.INTL with a weekend pattern, for example =NETWORKDAYS.INTL(A2, B2, 7) treats only Friday and Saturday as the weekend.
A short reference for these functions appears in the table below. For a deeper walkthrough of the same idea with extra screenshots and edge cases, see the guide on How to Calculate Business Days Between Dates in Excel.
| Function | Purpose | Weekend | Holidays argument |
|---|---|---|---|
| NETWORKDAYS | Count weekdays between two dates (inclusive) | Saturday & Sunday | Optional range of dates |
| NETWORKDAYS.INTL | Same as NETWORKDAYS with custom weekend pattern | Configurable via code | Optional range of dates |
| WORKDAY | Return a date N business days after a start date | Saturday & Sunday | Optional range of dates |
| WORKDAY.INTL | WORKDAY with custom weekend pattern | Configurable via code | Optional range of dates |
Use the Business Days Calculator Step by Step
When you don't have a spreadsheet handy, the Business Days Calculator runs the same NETWORKDAYS-style logic directly in your browser. Here is the standard workflow.
- Pick your start date. The calculator defaults to today, so change it to the date your period actually begins.
- Pick your end date. The business-day count, total calendar days, and weekend-days figures update instantly, with no button to press.
- If your period spans public holidays, paste them into the optional field as comma-separated YYYY-MM-DD dates, for example 2024-12-25, 2024-12-26, 2025-01-01. Each qualifying holiday is removed from the working-day total.
- Read the result next to the inputs. The displayed "weekend days" tells you how many Saturdays and Sundays were skipped, and "holidays excluded" tells you how many of your listed holidays landed on a weekday inside the range.
Everything runs locally on your device, so the dates you enter are not uploaded to any server.
How the Calculator Counts Working Days
The tool uses the same full-weeks-plus-remainder method that Excel's NETWORKDAYS and well-known date libraries rely on. It first measures the whole calendar span between your two dates, then takes the number of complete weeks inside that span and multiplies by 5, because every complete week contains exactly five weekdays. The leftover days at the start and end of the range are then walked one at a time, and each leftover day that is not a Saturday or Sunday is added to the count. This approach stays exact across month boundaries, leap years (February 29 is included when it is a weekday), and year rollovers. Because the count is inclusive of both endpoints, Monday to Friday in the same week gives 5 business days and a single weekday selected on its own gives 1. If your workflow needs an exclusive count (the difference between two dates with the start day removed), subtract 1 from the displayed total yourself.
Excluding Public Holidays in Excel and the Tool
Holidays are the one input that changes a business-day answer the most, and the same rules apply in both Excel and the browser calculator. A holiday only reduces the weekday total when it falls inside the date range and lands on a Monday through Friday; a holiday that lands on a Saturday or Sunday is ignored because that day was never a working day in the first place. A date listed twice is subtracted only once, so duplicating a public holiday by accident will not double-count it. In Excel, you can pass a single cell range like D2:D10, or you can pass an array constant such as {"2024-12-25","2024-12-26"}; in the calculator, paste a comma-separated list of YYYY-MM-DD dates into the optional field and the filter is applied instantly. Bounding the holiday list to the actual date range you entered is also a sensible sanity check, because holidays outside the range can never affect the count.
Common Workflows That Need This Count
Business-day counts are the unit most projects, payroll runs, shipping estimates, and service-level agreements are actually measured in. Setting realistic project deadlines and sprint end dates almost always starts from a known start date and adds working days rather than calendar days. Calculating payroll or billable working days in a period is the same problem: count the weekdays, then subtract the holidays the company observes. Estimating delivery and shipping windows is another everyday use, since carriers quote transit times in business days. Tracking contract or SLA turnaround times is essentially a NETWORKDAYS computation, and planning notice periods is the WORKDAY variant. In every case, the goal is the same: reflect the days work actually happens, not raw calendar days.
Excel vs the Browser Calculator
Both tools return the same answer for the standard Mon-Fri case, because the browser calculator is built around the same inclusive weekday rule as NETWORKDAYS. The difference is where each one earns its place. Excel is the right choice when the calculation lives inside a larger spreadsheet, when you need to chain the result into other formulas, or when you are computing business days for hundreds of rows at once. The Business Days Calculator is the right choice when you want a quick answer without opening a workbook, when you need to verify an Excel result before sending it, or when you are working with a non-spreadsheet collaborator who just needs a number. A common pattern is to build the formula in Excel for the live workbook and then cross-check one or two rows against the calculator to make sure the inputs and the holiday list are wired up correctly.
A Worked Example You Can Replicate
To anchor the method, take a single weekday range: start = 2024-01-01 (a Monday) and end = 2024-01-15 (also a Monday), with no holidays. The calendar span is 15 days, which contains two complete weeks (2024-01-01 through 2024-01-07 and 2024-01-08 through 2024-01-14). Two complete weeks at 5 weekdays each gives 10 business days. The leftover day is 2024-01-15, which is a Monday, so add 1 more weekday. The total is 10 + 1 = 11 business days, and the Saturday and Sunday count is 4 (Jan 6, 7, 13, 14). The same call in Excel is =NETWORKDAYS(DATE(2024,1,1), DATE(2024,1,15)) and the same call in the browser tool returns 11 business days, 15 total days, and 4 weekend days. If you remove a holiday that lands on a weekday inside the range, the business-day total drops by 1.