Formualizer Docs
ReferenceFunctionsDate & Time Functions

NETWORKDAYS.INTL

NETWORKDAYS.INTL: Returns the number of working days between two dates with configurable weekends.

Summary

Returns the number of working days between two dates with configurable weekends.

Remarks

  • The weekend argument can be a number code (1-7, 11-17) or a 7-character string of 0s and 1s (Mon-Sun, 1 = weekend day). Default is 1 (Sat/Sun).
  • The optional holidays argument accepts a range or array of date serials to exclude.
  • If start_date > end_date, the result is negative.
  • A weekend string of all 1s (no workdays) returns #VALUE!.

Examples

Default weekends (same as NETWORKDAYS)
Grid
CellValue
No inputs on Sheet1.
Formula
=
Result
Not evaluated yet.
Expected
23
Friday-only weekend
Grid
CellValue
No inputs on Sheet1.
Formula
=
Result
Not evaluated yet.
Expected
6
Custom weekend string (Mon+Fri off)
Grid
CellValue
No inputs on Sheet1.
Formula
=
Result
Not evaluated yet.
Expected
5

FAQ

What happens if the weekend string is all 1s?

NETWORKDAYS.INTL returns #VALUE! because there would be no workdays.

Runtime metadata

Category

Date & Time

Signature

NETWORKDAYS.INTL(arg1: Number, arg2: Number, arg3: Any, arg4…: Any)

Arity

min 2, max variadic

Arguments

arg1

Number · Scalar · coercion NumberLenientText

arg2

Number · Scalar · coercion NumberLenientText

arg3

Any · Scalar

arg4

Any · Scalar

Caps

PURE

Source

crates/formualizer-eval/src/builtins/datetime/weekday_workday.rs

NETWORKDAYS

NETWORKDAYS: Returns the number of weekday business days between two dates, inclusive.

NOW

NOW: Returns the current date and time as a volatile datetime serial.

On this page

SummaryRemarksExamplesRelated functionsFAQWhat happens if the weekend string is all 1s?Runtime metadata