NETWORKDAYS.INTL (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
Syntax
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 |
|
weekend | A number or string that specifies when weekends occur. Weekend days are days of the week that are not included in the number of whole working days between startdate and enddate | StringOrNumber | Y |
holidays | Range of dates to exclude from the calculation. Holidays can be a range of cells that contain the dates, or an array constant of the serial values that represent those dates | StringOrNumber | Y |
Comments
This function is the same as the Microsoft Excel 'NETWORKDAYS.INTL' function - using the same inputs, logic and outputs.