Formualizer Docs
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.
  • Optional holidays arguments are excluded from the count and may be provided as scalars, inline arrays, or ranges.
  • Input serials are interpreted with Excel 1900 date mapping.

Examples

Count weekdays in a range
Grid
CellValue
No inputs on Sheet1.
Formula
=
Result
Not evaluated yet.
Expected
6
Holiday exclusions reduce the count
Grid
CellValue
No inputs on Sheet1.
Formula
=
Result
Not evaluated yet.
Expected
5

FAQ

Can I exclude custom holidays in NETWORKDAYS?

Yes. Additional arguments can provide holiday serials, arrays, or ranges to exclude from the weekday count.

Runtime metadata

Category

Date & Time

Signature

NETWORKDAYS(arg1: Number, arg2: Number, arg3…: Any)

Arity

min 2, max variadic

Arguments

arg1

Number · Scalar · coercion NumberLenientText

arg2

Number · Scalar · coercion NumberLenientText

arg3

Any · Scalar

Caps

PURE

Source

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

MONTH

Extracts the month number (`1` to `12`) from a date serial.

NETWORKDAYS.INTL

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

On this page

SummaryRemarksExamplesRelated functionsFAQCan I exclude custom holidays in NETWORKDAYS?Runtime metadata