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
Date that is the starting date; a number (as in 37806.5), or a DateTime object, as in DATE(2003,7,4)
Date that is the ending date; a number (as in 37806.5), or a DateTime object, as in DATE(2003,7,4)
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
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
This function is the same as the Microsoft Excel 'NETWORKDAYS.INTL' function - using the same inputs, logic and outputs.