workday( starting_date, days, holidays )
Returns the date the given number of workdays before or after the given date.
Keyword | Type | Description |
---|---|---|
|
Date |
The starting date. |
|
Integer |
The number of days to advance into the future (positive numbers) or days to retreat into the past (negative numbers). |
|
Date |
A list of holidays not counted as workdays. |
Date
An array of holidays may be given by enclosing them in braces, such as {"12/25/2004","12/31/2004"}
.
workday(date(2011,12,13),-6)
returns 12/5/2011