NETWORKDAYS

The NETWORKDAYS function returns the number of working days between two dates. The input dates can be specified as date values, references, or measures that contain dates. This function is commonly used to calculate business days, project durations, and turnaround times.

Syntax

NETWORKDAYS(fromDate, toDate)

Arguments

• fromDate: The start date of the range.
• toDate: The end date of the range.

Return value

Returns the number of working days between the specified dates.

Example

NETWORKDAYS("05/31/2026", "06/30/2026")

Returns the number of working days between 05/31/2024 and 06/30/2024, excluding weekends.

Excel equivalent

NETWORKDAYS