NETWORKDAYS (PQL - xl)
This function returns the total number of complete working days between the start and end dates
- Library: PQL \ Spreadsheet \ Date & Time
- Compatibility: Any content (regardless of data source) in the Tabulate spreadsheet module
- Solve: This function can be used with the Solve plug-in: both as part of the objective function and constraint functions
Syntax
NETWORKDAYS(start date, end date, OPTIONAL holidays)
Function Arguments
Name | Description | Type | Optional |
start date | Date that is the starting date; a number (as in 37806.5), or a DateTime object, as in DATE(2003,7,4) | StringOrNumber |
|
end date | Date that is the ending date; a number (as in 37806.5), or a DateTime object, as in DATE(2003,7,4) | StringOrNumber |
|
holidays | Range of dates to exclude from the calculation; if omitted, the calculation assumes no holidays and all weekdays are workdays | StringOrNumber | Y |
Comments
This function is the same as the Microsoft Excel 'NETWORKDAYS' function - using the same inputs, logic and outputs.