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.
