Date & Time

Excel NETWORKDAYS Function

Count working days between two dates, excluding weekends (and optional holidays).

Syntax

NETWORKDAYS(start_date, end_date, [holidays])

Generate NETWORKDAYS with AI All functions

Arguments

start_daterequired

The start date.

end_daterequired

The end date.

holidaysoptional

A range of dates to also exclude.

What the NETWORKDAYS function does

NETWORKDAYS returns the number of whole working days between two dates, automatically skipping Saturdays and Sundays. Pass a holidays range to exclude those too — ideal for SLAs, delivery estimates, and project timelines.

Examples

=NETWORKDAYS(A2, B2)→22

Working days between two dates (weekends excluded).

=NETWORKDAYS(A2, B2, H2:H6)→20

Also excludes the holiday list in H2:H6.

How to use NETWORKDAYS

Set start and end

Reference the two dates to span.

Add a holidays range

Optionally exclude public holidays.

FAQ

Can I change which days are weekends?

Yes — use NETWORKDAYS.INTL with a weekend code for non-Sat/Sun weekends.

Related functions

TODAY EOMONTH WEEKDAY