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
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)
Range of dates to exclude from the calculation; if omitted, the calculation assumes no holidays and all weekdays are workdays
This function is the same as the Microsoft Excel 'NETWORKDAYS' function - using the same inputs, logic and outputs.