Excel NETWORKDAYS: Count Workdays Between Two Dates

Formulas & functions · Updated November 19, 2026

To count working days 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 and includes both endpoint dates when they fall on weekdays.

What NETWORKDAYS counts

NETWORKDAYS returns the number of working days in a date range, using a standard Monday-to-Friday workweek. Saturday and Sunday are excluded automatically. You can also provide a list of holidays to exclude, or use the related NETWORKDAYS.INTL function when your weekend days differ from the standard pattern.

The function is useful for practical questions such as how many business days a project took, how many weekdays fall in a reporting period, or how long a service request has been open. Its result is a count of dates, not a count of elapsed 24-hour periods. It does not account for working hours, part-time schedules, or the time portion of date-time values.

One important detail is that the range is inclusive: the start and end dates are both considered. A weekday start date and weekday end date each contribute one day unless they are listed as holidays. If an endpoint is Saturday or Sunday under the default calendar, it contributes zero.

Syntax and arguments

The function takes a start date, an end date, and an optional holiday range. In the basic example, A2 contains the first date and B2 contains the last date. The optional third argument is a range or array of dates to treat as holidays:

  • start_date: the first date in the period.
  • end_date: the final date in the period.
  • holidays: an optional list of dates to exclude, such as public holidays or company closure days.

The arguments can be cell references, date values, or—in the case of holidays—a range of cells. Cell references are usually easier to maintain than dates typed directly into a formula. Excel stores recognized dates as serial numbers, so a cell formatted to display a date can be used normally by the function.

A worked example

Suppose A2 contains January 1, 2024, and B2 contains January 10, 2024. With those dates in the two cells, enter:

=NETWORKDAYS(A2,B2)

The result is 8. The weekdays counted are January 1–5 and January 8–10. January 6 and 7 are Saturday and Sunday, so they are skipped. This also shows why “days between” can be an ambiguous phrase: the function counts the dates at both ends, rather than simply measuring the number of nights or 24-hour intervals separating them.

If you reverse the start and end dates, NETWORKDAYS returns a negative count. That behavior can be useful when the direction matters, but it can also reveal a data-entry mistake. If your report should never show a negative duration, validate that the start date is on or before the end date, or handle reversed inputs deliberately.

Exclude holidays

To remove holidays from the count, place actual Excel dates in a holiday list and supply that range as the third argument. For example, assume A2 is January 1, 2024, B2 is January 10, 2024, C2 contains January 1, and C3 contains January 8. Use:

=NETWORKDAYS(A2,B2,C2:C3)

The result is 6: the original eight weekdays minus the two listed dates. The holiday range can be on the same worksheet or another worksheet in the workbook. Keep the holiday list in date-value cells, not text that merely looks like a date. Extra blank cells in a holiday range are generally ignored, so you can reference a longer list as it grows.

A holiday that already falls on a weekend does not reduce the count further, because that date was excluded as a weekend in the first place. A holiday list can include organization-specific closures as well as public holidays, but it is your responsibility to decide which dates count as nonworking days for the calendar being measured.

Use a different weekend schedule

If the workweek is not Monday through Friday, use NETWORKDAYS.INTL. It accepts the same start, end, and optional holiday arguments, plus an option for defining weekend days. For example, suppose A2 is Friday, January 5, 2024, and B2 is Monday, January 8, 2024. To treat Friday and Saturday as weekend days, enter:

=NETWORKDAYS.INTL(A2,B2,"0000110")

The result is 1, because Friday and Saturday are marked as weekends, Sunday is not, and Monday is counted. In the seven-character weekend string, the characters represent Monday through Sunday in order; 1 means a nonworking day and 0 means a working day. Thus, "0000011" represents the usual Saturday-and-Sunday weekend.

NETWORKDAYS.INTL also supports numeric weekend codes for common weekend patterns. The text pattern is useful when the schedule is unusual or when you want the weekend definition to be visible in the formula. Check the positions carefully: a single misplaced 1 changes which dates are excluded. You can add a holiday range after the weekend argument when both rules apply.

NETWORKDAYS versus WORKDAY

These similarly named functions answer different questions. NETWORKDAYS counts working days between two dates. WORKDAY starts from a date and moves forward or backward by a specified number of working days, skipping weekends and optional holidays. Use the first when you need a duration; use the second when you need a projected workday deadline.

For example, if A2 contains January 1, 2024, and B2 contains 5, the following returns January 8, 2024. It skips the weekend after the starting date while moving forward five workdays:

=WORKDAY(A2,B2)

January 1 is treated as the starting point, not as one of the five days moved forward. If your deadline calculation must skip holidays, provide a holiday range to WORKDAY as well. Remember that WORKDAY returns a date, whereas NETWORKDAYS returns a number.

Common errors and date handling

If a result looks wrong, first verify that Excel recognizes every input as a date. A value imported from a text file may display like a date but remain text, or it may have been interpreted according to a different regional date order. For example, 03/04/2024 can mean March 4 or April 3 depending on the source convention. Use unambiguous dates during data import and check the underlying values before relying on a count.

  • Unexpected zero: the range may contain only weekend dates, or the start and end date may be the same weekend day.
  • Unexpected negative result: the start date may be later than the end date.
  • Wrong holiday count: confirm the holiday cells contain real dates and that the range includes the full list.
  • Error result: check for text or invalid date inputs, and confirm that referenced cells contain values Excel can interpret as dates.

NETWORKDAYS works with calendar dates rather than business hours. A date-time value is treated as its date for this type of count; a time such as 9:00 a.m. does not make the function count a fraction of a workday. If the task is to calculate hours or shifts, use a method designed for time values instead of interpreting NETWORKDAYS as an hours calculation.

For a worksheet that should stay blank until both dates are entered, assume the start date is in A2 and the end date is in B2. Use this guarded formula:

=IF(OR(A2="",B2=""),"",NETWORKDAYS(A2,B2))

It displays a blank if either input is empty; otherwise it calculates the count. This avoids showing a misleading result while someone is still filling in the row. Ensure the cells are genuinely blank when appropriate, rather than containing a space character.

Set up a reliable workday count

For a recurring report, separate the inputs from the calculation. Put start and end dates in clearly labeled columns, keep holidays in a dedicated list, and copy the formula down the results column. Format the input cells as dates so people can recognize what they are entering, while remembering that formatting alone does not convert text into a real date.

Before sharing the workbook, verify a few rows manually. Check a period containing a weekend, a period containing a listed holiday, and a row whose start and end dates are the same. These checks help catch an incorrect holiday range or a reversed date pair. If different teams use different workweeks, document which weekend pattern and holiday calendar the result represents; “business day” is not universal across organizations or countries.

In Microsoft 365 for Windows, these functions are entered directly in a worksheet cell and are available without an add-in. Excel for Mac and Excel for the web also support NETWORKDAYS and NETWORKDAYS.INTL; the formulas are the same, although ribbon layout and some interface details can differ. The key requirements are valid date inputs and a calendar definition that matches the question.

Frequently Asked Questions

Does NETWORKDAYS include the start and end dates?
Yes. It counts both endpoints if they are working days and are not in the holiday list. Weekend endpoints are excluded under the selected weekend pattern.

How do I count workdays between two dates excluding holidays?
Put the holiday dates in a range and use it as the third argument, for example =NETWORKDAYS(A2,B2,C2:C20) when A2 and B2 hold the dates and C2:C20 holds the holiday list.

How do I count workdays when the weekend is Friday and Saturday?
Use NETWORKDAYS.INTL with the weekend pattern "0000110", where Monday through Sunday are represented from left to right and 1 marks a weekend day.

Why does NETWORKDAYS return a negative number?
The end date is earlier than the start date. Swap the dates if that is an input error, or keep the negative value if the direction of the interval is meaningful to your calculation.

What is the difference between NETWORKDAYS and WORKDAY?
NETWORKDAYS counts working dates within a range. WORKDAY calculates a date a given number of working days before or after a starting date.

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.