Function Reference: WORKDAY.INTL and WORKDAY
| Syntax | ||||||||||||||||||||||||||||||
| =WORKDAY.INTL(start_date,days,[weekend],[public_holidays]) =WORKDAY(start_date,days,[public_holidays]) |
||||||||||||||||||||||||||||||
| Purpose / Description | ||||||||||||||||||||||||||||||
| Each of these functions returns the date of a day the given number of days before negative value)or after (positive value) a starting date. Optionally, a list of public holiday dates can be provided, which will be considered non-working days. In the case of WORKDAY.INTL, it is possible to specify all possible combinations of weekend / non-trading days. The WORKDAY function is an older function and assumes that the weekend falls on Saturday and Sunday, which is less flexible for many modern trading patterns.. | ||||||||||||||||||||||||||||||
| Arguments | ||||||||||||||||||||||||||||||
| Name | Type | Description | ||||||||||||||||||||||||||||
| start_date | number | A constant, reference or nested expression which provides the serial date number from which the target date will be calculated. Any decimal portion, assumed to be time of day is ignored. | ||||||||||||||||||||||||||||
| days | number | A constant, reference or nested expression which provides the number of days back in time (negative value) or forward in time (positive value) to the date to be calculated. the calculation skips the non-working days in the given weekend (WORKDAY.INTL) or the assumed weekend of Saturday and Sunday (WORKDAY). It also skips any dates in the optional argument public_holidays. | ||||||||||||||||||||||||||||
| [public_holidays] | array of numbers | An optional constant, array of constants, range reference or nested expression that provides one or more serial date numbers which are to be considered non-working days in calculating the workday that is days from start_date. Any decimal portion, assumed to relate to time of day is ignored. | ||||||||||||||||||||||||||||
| [weekend] | number | For WORKDAY.INTL only, this is an optional constant, reference or nested expression which indicates which days are to be considered non-working days. Defaults to 1 if omitted
|
||||||||||||||||||||||||||||
| Return Values | ||||||||||||||||||||||||||||||
| Type | Specific Value | Description | ||||||||||||||||||||||||||||
| number | A serial date number representing the date days before (negative value) or after (positive value) start_date. If days is 0, the whole number portion of start_date is returned. | |||||||||||||||||||||||||||||
| error | #VALUE! | If any of the arguments are not numbers and cannot be coerced to number. | ||||||||||||||||||||||||||||
| error | #NUM! | If the number passed to start_date or the result of the function is outside the range allowed. 1900 date system: 0 to 2,958,465 1904 date system: 0 to 2,957003 |
||||||||||||||||||||||||||||
| error | Any errors referenced by arguments are returned due to propagation of error values. | |||||||||||||||||||||||||||||
| Notes / Comments / Advice / Warnings | ||||||||||||||||||||||||||||||
| Advice: | We advise using WORKDAY.INTL if doing this type of calculation, as it keeps the idea front of mind that you can adjust the weekend / no-trading days. | |||||||||||||||||||||||||||||
| Examples: | Open / download sample workbook:: WEEKDAY, WORKDAY.INTL, WORKDAY.xlsx | |||||||||||||||||||||||||||||