NETWORKDAYS

The NETWORKDAYS function returns the number of workdays between two dates. It accepts two dates as inputs.

Syntax

NETWORKDAYS(fromDate,toDate)

Arguments

fromDate - Starting date in the range. Required. This can be a date, a node reference or a measure that includes the date.

toDate- Ending date in the range. Required. This can be a date, a node reference or a measure that includes the date.

Return value

Number.

Example

NETWORKDAYS("05/31/2024","06/30/2024")
//Returns 22

NETWORKDAYS