NETWORKDAYS

NETWORKDAYS number of workdays in range

Synopsis

NETWORKDAYS(start_date,end_date,holidays,weekend)

Arguments

start_date: starting date serial value

end_date: ending date serial value

holidays: array of holidays

weekend: array of 0s and 1s, indicating whether a weekday (S, M, T, W, T, F, S) is on the weekend, defaults to {1,0,0,0,0,0,1}

Description

NETWORKDAYS calculates the number of days from start_date to end_date skipping weekends and holidays in the process.

Note

If an entry of weekend is non-zero, the corresponding weekday is not a work day.

Microsoft Excel Compatibility

This function is Excel compatible if the last argument is omitted.

OpenDocument Format (ODF) Compatibility

This function is OpenFormula compatible.

See also

WORKDAY.