ƒxPlainFormulaThink in English. Formula in Excel.

FUNCTION CATALOGUE / DATE & TIME

NETWORKDAYS Excel function

Counts working days between dates.

Correct sentence to use

Count working days from [start date] to [end date].

Modify this query in PlainFormula →

Example formula

=NETWORKDAYS(A2,B2)

Counts workdays excluding weekends and optionally holidays.

Syntax

NETWORKDAYS(start_date, end_date, [holidays])

Argument signature: start_date, end_date, [holidays]

Availability note

Commonly available in current Excel; verify platform and locale-specific behaviour.

Check Microsoft's Excel function documentation ↗

← Browse all functions