NETWORKDAYS

What it does

NETWORKDAYS counts the weekdays from a start date to an end date, both included, and leaves out weekends. You can also give a list of holidays to leave out.

Syntax

=NETWORKDAYS(start_date; end_date; [holidays])

Arguments in square brackets are optional, and … means you can add more of the same. In this Excel language, arguments are separated by ;

Arguments

start_date

The first day of the period.

end_date

The last day of the period. It is counted too.

holidays

Optional: a range of dates that aren't working days, such as public holidays.

Example

How many working days are there from 2 to 13 November 2026, with a holiday on the 11th?

The formula in D2:

=NETWORKDAYS(A2;B2;C2)

Result: 9

The two weeks from Monday 2 November to Friday 13 November have 10 weekdays. The holiday on Wednesday 11 November is left out, which leaves 9.

Common mistakes

• Forgetting that both the start and end day count. From Monday to Friday of the same week is 5, not 4.
• Typing holidays as text that only looks like dates. The holiday cells must hold real dates.
• Using it when the weekend isn't Saturday and Sunday. NETWORKDAYS.INTL lets you choose the weekend days.

In other Excel languages

Excel translates function names, and in some languages the argument separator too. Type the name your Excel shows.

Practise it

• NETWORKDAYS: working daysModule 9 · Dates

More from this module

• DATE
• TODAY
• YEAR
• MONTH
• DAY
• WEEKDAY
• DAYS
• DATEDIF
• EOMONTH

All functions