Google Sheets Function

NETWORKDAYS

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

Generate a formula with AI Same function in Excel

This function works the same in Google Sheets as it does in Excel — same syntax and arguments.

Syntax

NETWORKDAYS(start_date, end_date, [holidays])

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.

Arguments

start_daterequiredThe start date.
end_daterequiredThe end date.
holidaysoptionalA range of dates to also exclude.

Examples

=NETWORKDAYS(A2, B2)

Result: 22

Working days between two dates (weekends excluded).

=NETWORKDAYS(A2, B2, H2:H6)

Result: 20

Also excludes the holiday list in H2:H6.

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