Home/Formulas/Date/NETWORKDAYS
Datemedium

NETWORKDAYS()

Returns the count of working days (Mon-Fri) between two dates, excluding optional holidays.

Syntax
fx
=NETWORKDAYS(start_date, end_date, [holidays])
Arguments
ArgumentDescription
start_dateThe start of the range (inclusive).
end_dateThe end of the range (inclusive).
[holidays]An optional range of dates to treat as non-working days.
Example
fx
=NETWORKDAYS("2026-01-01", "2026-01-15")

Paste this into Google Sheets to run it. The live playground on this site covers 24 of the 61 functions, and NETWORKDAYS isn't one of them yet.

Related formulas
WEEKDAY()
Returns the day of the week for a date, as a number (default Sunday=1, Saturday=7).
DATEDIF()
Calculates the number of days, months, or years between two dates.
DATE()
Constructs a date value from year, month, and day numbers.
Used by
DATEDIF()
Calculates the number of days, months, or years between two dates.
WEEKDAY()
Returns the day of the week for a date, as a number (default Sunday=1, Saturday=7).
More Date formulas →Keyboard shortcuts for Sheets →