Excel Workdays Between Dates: Formulas and Examples

Formulas & functions · Updated November 19, 2026

To count workdays between two dates in Excel, use NETWORKDAYS. With the start date in A2 and the end date in B2, enter =NETWORKDAYS(A2,B2); Excel counts Monday through Friday, includes both endpoint dates when they are weekdays, and does not exclude holidays unless you provide them.

The basic workday count

NETWORKDAYS is the standard function for counting working days in a date range. It is useful for estimating business-day turnaround, counting scheduled weekdays in a reporting period, or checking how many weekdays fall between a project’s start and finish. The result is a number, so you can use it in other calculations or display it as a count.

For example, January 5 through January 16, 2026, covers two Monday-to-Friday weeks. With January 5 in A2 and January 16 in B2, =NETWORKDAYS(A2,B2) returns 10. The dates at both ends count if they fall on working days. That inclusive rule matters: a Monday-to-Friday range that starts and ends on weekdays includes both Mondays or Fridays at its edges, rather than counting only the days strictly between them.

The function treats Saturday and Sunday as weekend days by default. It does not know your organization’s holiday calendar, local observances, or employee schedule. Add a holiday list or use a custom-weekend function when those details affect the answer.

How the formula counts dates

Excel stores valid dates as serial numbers and evaluates the dates in the range against the standard weekend pattern. In broad terms, it counts weekdays from the first date through the last date, then subtracts any listed holidays that fall on weekdays within that range. A holiday on a Saturday or Sunday does not reduce the count again because it was already a nonworking day.

Inclusive counting can produce results that surprise people who interpret “between” as excluding the start and end. If A2 and B2 contain the same Tuesday, =NETWORKDAYS(A2,B2) returns 1. If they contain the same Saturday, it returns 0. For a range beginning Friday and ending Monday, the result is 2, not 1: Friday and Monday are both counted, while the weekend is not.

If the start date is later than the end date, Excel returns a negative count. That can be useful in some calculations, but it is often a sign that the two date cells were reversed. Check the source values before interpreting a negative answer as a genuine duration.

Exclude public or company holidays

Put holidays in worksheet cells as real Excel dates, then pass the holiday range as the third argument. For example, suppose A2 contains January 5, 2026, B2 contains January 16, 2026, and E2 contains January 12, 2026. With those cells as the layout, enter =NETWORKDAYS(A2,B2,$E$2:$E$2). The result is 9 because the ten weekdays in the range include one listed weekday holiday.

For a longer calendar, list holidays in E2:E20 and use =NETWORKDAYS(A2,B2,$E$2:$E$20), with the same start and end cells and the holiday dates in E2:E20. The dollar signs keep the holiday range fixed if you copy the formula down a column, while A2 and B2 can adjust for each row. Blank cells in the holiday range are ignored.

Use actual date values rather than text that merely looks like a date. A value copied from another system may be stored as text, and a text date may not be recognized as a holiday. You can check by changing the cell’s number format to General: a genuine Excel date displays as a serial number. Also make sure the holiday list and the counted dates use compatible date interpretations; ambiguous entries such as 04/05/2026 can mean different dates under different regional settings.

Use a custom weekend schedule

Some workplaces do not use Saturday and Sunday as their weekend. NETWORKDAYS.INTL lets you specify which days are nonworking, while retaining an optional holiday list. Its weekend argument can be a numeric code or a seven-character pattern, ordered Monday through Sunday, where 1 marks a nonworking day and 0 marks a working day.

For a Monday-to-Friday workweek with Saturday and Sunday off, and start and end dates in A2 and B2 plus holidays in E2:E10, enter =NETWORKDAYS.INTL(A2,B2,1,$E$2:$E$10). The weekend code 1 represents the usual Saturday-Sunday weekend. This produces the same kind of count as NETWORKDAYS when the schedule is the standard one.

For a Sunday-to-Thursday workweek with Friday and Saturday off, use the seven-day pattern 0000110: Monday through Thursday are working days, and Friday and Saturday are not. With the same cell layout, the formula is =NETWORKDAYS.INTL(A2,B2,"0000110",$E$2:$E$10). Check the order carefully: the first character always describes Monday, not Sunday. Numeric weekend codes cover several common patterns, while the text pattern can express other combinations, including a single nonworking day.

Enter dates and troubleshoot errors

When a result seems wrong, first inspect the date values themselves. A cell formatted to look like a date can still contain text, and imported dates may be interpreted differently from dates typed into the workbook. Confirm that start and end dates are valid Excel dates, and inspect the holiday list for text values, duplicates, or dates outside the interval.

Common checks include:

  • Confirm that the start date is not later than the end date unless a negative count is intentional.
  • Check whether either endpoint is a weekend or holiday; an endpoint does not count if it is a nonworking day.
  • Verify the holiday range includes every intended date and does not accidentally include unrelated cells.
  • For a custom schedule, confirm that the weekend code or Monday-first pattern matches the actual days off.
  • If Excel shows a formula error, check that the cells contain valid date values and that the formula’s parentheses and separators are correct for your Excel settings.

In Microsoft 365 for Windows, commas are the usual argument separators in English-language formulas. Some regional settings use semicolons instead, so Excel may require those when you enter a formula. Microsoft 365 for Mac and Excel for the web use the same functions and counting rules; the interface or regional separators can differ, but the calculation does not.

Choose between NETWORKDAYS and NETWORKDAYS.INTL

Use NETWORKDAYS when the weekend is Saturday and Sunday. It is shorter and makes the assumption obvious to someone reviewing the workbook. Use NETWORKDAYS.INTL when the weekend differs, or when you want the weekend pattern to be explicit in the formula. Both functions accept a holiday range, and both count the endpoint dates when they are working days.

These functions answer a different question from simply subtracting one date from another. With A2 as the start date and B2 as the end date, =B2-A2 gives elapsed calendar days between the dates and excludes the start date from that difference. It does not remove weekends or holidays. Choose date subtraction for elapsed time; choose a NETWORKDAYS function for a count of scheduled working dates.

Both NETWORKDAYS functions are available in current Microsoft 365 versions, including Windows, Mac, and the web. They are also present in many earlier Excel releases, though workbook compatibility can matter when sharing files with older software. If a recipient’s version does not recognize a function, confirm the supported version before relying on the result.

Related calculation: find a date after workdays

A count and a deadline calculation are related but not interchangeable. If you need to find the date a given number of workdays after a start date, use WORKDAY; it returns a date rather than a count. For example, if A2 contains Friday, January 9, 2026, enter =WORKDAY(A2,1) to get Monday, January 12, 2026, assuming the standard weekend and no holidays. WORKDAY does not count the starting date as day one.

To skip holidays too, list them in E2:E10 and, with the start date in A2, enter =WORKDAY(A2,1,$E$2:$E$10). A holiday that falls on the expected next working day pushes the returned date forward. Use NETWORKDAYS when you want the number of working dates in a known interval, and WORKDAY when you know a starting point and want a later or earlier workday date.

Frequently Asked Questions

Does Excel count the start and end dates?
Yes. NETWORKDAYS counts both dates if they are working days under the selected weekend schedule and are not listed as holidays. A weekend or holiday endpoint is excluded.

How do I count workdays excluding holidays?
Store the holiday dates in worksheet cells and add that range as the third argument to NETWORKDAYS. For a nonstandard weekend, use NETWORKDAYS.INTL and provide both the weekend pattern and holiday range.

Why does my formula return zero?
The interval may contain no working dates, such as a range consisting only of a Saturday and Sunday. It may also be a single weekend date. Check the actual dates and the weekend setting before assuming the formula has failed.

Can I count workdays when the weekend is Friday and Saturday?
Yes. Use NETWORKDAYS.INTL with a weekend pattern or numeric weekend code that marks Friday and Saturday as nonworking days. Confirm the pattern’s Monday-through-Sunday order before applying it to a full schedule.

What is the difference between NETWORKDAYS and WORKDAY?
NETWORKDAYS returns the number of working days within a date interval. WORKDAY returns a date a specified number of working days before or after a start date. Both can account for holidays when you provide a holiday range.

Related

Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.

More in Formulas & functions

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.