ReferenceFunctionsDate & Time Functions
NETWORKDAYS
NETWORKDAYS: Returns the number of weekday business days between two dates, inclusive.
Summary
Returns the number of weekday business days between two dates, inclusive.
Remarks
- Weekends are fixed to Saturday and Sunday.
- If
start_date > end_date, the result is negative. - The optional
holidaysargument is currently accepted but ignored; holiday exclusions are not yet supported. - Input serials are interpreted with Excel 1900 date mapping.
Examples
Count weekdays in a range
Grid
| Cell | Value | |
|---|---|---|
| No inputs on Sheet1. | ||
Formula
=
Result
Not evaluated yet.
Expected
6
Holiday argument currently has no effect
Grid
| Cell | Value | |
|---|---|---|
| No inputs on Sheet1. | ||
Formula
=
Result
Not evaluated yet.
Expected
6
Related functions
FAQ
Are custom holidays excluded in NETWORKDAYS right now?
Not yet. The third argument is accepted but currently ignored, so only Saturday/Sunday weekends are excluded.
Runtime metadata
Category
Date & Time
Signature
NETWORKDAYS(arg1: Number, arg2: Number, arg3…: Any)Arity
min 2, max variadic
Arguments
arg1Number · Scalar · coercion NumberLenientText
arg2Number · Scalar · coercion NumberLenientText
arg3Any · Scalar
Caps
PURE
Source