WORKDAY (PQL - xl)
This function returns the number of working days before or after the starting date
- Library: PQL \ Spreadsheet \ Date & Time
- Compatibility: Any content (regardless of data source) in the Tabulate spreadsheet module
Syntax
WORKDAY(start date, days, 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 |
|
days | Number of non-weekend or non-holiday days before or after the starting date; days in the future are positive and days in the past are negative; if not an integer, the number is truncated | Number |
|
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 'WORKDAY' function - using the same inputs, logic and outputs.