Knowledge base / Excel

NETWORKDAYS in Excel: inclusive dates and holiday calendars

I count Monday through Friday and show why a Saturday holiday does not reduce the result a second time.

Kajo RudzińskiPublished Updated 5 min read

Cubes from working calendar tiles are collected in a separate tray

When I have a start date and an end date, I sometimes need the number of working days within that interval. In Excel, I use NETWORKDAYS. It returns a day count under the chosen calendar of weekends and additional days off.

The key detail is that both interval endpoints are included when they are working days. Monday through Friday therefore contains five working days. Simply subtracting the dates measures something different.

NETWORKDAYS syntax

In English Excel, I write:

=NETWORKDAYS(start_date,end_date,[holidays])

I supply two dates and, optionally, a range of additional days off. Square brackets mark an optional argument in the description; I do not type them into the actual formula. The standard weekend is Saturday and Sunday.

The Microsoft documentation describes whole working days and recommends supplying dates through DATE or as results of other formulas. Text that looks like a date can be interpreted differently depending on settings.

English examples here use commas. Argument separators depend on regional configuration. In Polish Excel, the functions are called DNI.ROBOCZE and DATA. NETWORKDAYS is available in Microsoft 365 and versions including Excel 2024, 2021, 2019 and 2016.

Monday through Friday, inclusive

Take a synthetic interval from 3 to 7 June 2024, without additional days off:

=NETWORKDAYS(DATE(2024,6,3),DATE(2024,6,7))

The answer is 5. I count Monday the 3rd, Tuesday the 4th, Wednesday the 5th, Thursday the 6th and Friday the 7th. Both endpoints are working days, so both contribute.

Start End Result without additional days off
2024-06-03 2024-06-03 1
2024-06-08 2024-06-08 0
2024-06-03 2024-06-07 5
2024-06-03 2024-06-09 5
2024-06-03 2024-06-10 6

Saturday, 8 June, does not become a working day just because it is both endpoints. Adding Monday, 10 June, increases the result to six. This table helps me check whether the chosen interval definition matches the process.

If a report should exclude the date a request was received, I describe that requirement separately and define the counted start accordingly. I avoid mechanically subtracting one from every answer: the start might already be a weekend or a day off.

Holidays come from a supplied list

In D2, I enter =DATE(2024,6,5). In this example, it represents an invented company closure. I then use:

=NETWORKDAYS(DATE(2024,6,3),DATE(2024,6,7),D2:D2)

The result is 4. Wednesday is excluded and the other four days remain working days. Excel does not automatically know the country or calendar the company follows. I need to supply the appropriate dates.

The list can contain more days and cover the report’s full period. When copying the formula, I keep a shared holiday range fixed, for example $D$2:$D$20. An accidentally shifting range could apply different calendars to comparable orders.

I also avoid labelling an example closure as a public holiday without establishing that separately. An operating calendar may include shutdowns or local days off. The function only needs dates, but the report’s reader should understand the list’s rules.

Two calendars show how a cap on a working tile removes one counted cube

A holiday on Saturday is not deducted twice

Consider 10 through 20 June 2024. Without additional exclusions, I count five days from Monday through Friday, then four from the following Monday through Thursday. The total is 9.

If I put Saturday, 15 June, on the holiday list, the result remains 9. Saturday was already excluded as a weekend. It is not deducted a second time.

If I instead exclude Wednesday, 12 June, the result becomes 8. That date previously belonged to the counted set. These dates illustrate the mechanism using a synthetic calendar, rather than describing any country’s holidays.

This is a useful reasonableness check. If manually adding a weekend date to a holiday list reduces the result, that date has probably been subtracted twice. Under the intended calendar, a particular date is either counted or excluded.

Different weekends with NETWORKDAYS.INTL

For a Friday-Saturday weekend, I use NETWORKDAYS.INTL, called DNI.ROBOCZE.NIESTAND in Polish:

=NETWORKDAYS.INTL(DATE(2024,6,3),DATE(2024,6,7),7)

Code 7 means Friday and Saturday. Within this interval, Monday through Thursday are counted, giving 4. Friday is excluded under the new weekend definition.

Microsoft documents the weekend codes and syntax. An additional holiday list belongs in the fourth argument. I do not move the ordinary function’s holiday argument across unchanged, because the third argument has a different role in the INTL version.

Working days, deadlines and hours worked

NETWORKDAYS returns the number of days within an interval. WORKDAY returns a date after a working-day offset. They can share a calendar while answering different questions about the starting point.

Five working days after Monday, 3 June, leads to Monday, 10 June. The inclusive interval from 3 through 10 June contains six working days. I therefore avoid expecting a direct matching count between the functions without accounting for the boundaries.

A count of working dates is not a record of time worked. It does not independently account for part-time schedules, shift lengths, absences or shutdowns missing from the calendar. Multiplying by eight needs an explicit assumption about working hours per day.

What I check before handing over the workbook

I format the result as a number because I expect a day count. Date formatting could make a correct answer of 5 look misleading. I also check that both inputs are real dates, the end represents the intended period and the holiday list covers the correct year and team.

For a value error, I return to the input types. For an unexpected difference of one day, I inspect the boundaries first. In a simple workbook, those questions often help more quickly than rewriting the entire formula.

For an exercise, take the week from 3 through 9 June 2024. Count the standard working days, then exclude Wednesday, then change the weekend to Friday-Saturday. For each version, list the dates that actually contribute. That makes the calendar behind the number visible.

Key takeaways

Does NETWORKDAYS include both endpoints?

Yes, when those dates are working days under the chosen calendar.

Does a Saturday holiday subtract another day?

No. Under the standard weekend definition, Saturday is already excluded.

Is the result a count of hours actually worked?

No. It counts working dates under a calendar. Hours and actual attendance need separate data.

AI was used in an automated way while working on this article. If you want to learn how to do it too, check out this project.

Kajo Rudziński

Newsletter KajoData

Let’s keep in touch.

I write about data analysis, learning and changing careers. My newsletter and the sign-up form are in Polish. If that works for you, I’d be glad to see you there.