WORKDAY.INTL function
Returns the serial number of the date before or after a specified number of workdays using parameters to indicate which and how many days are weekend days
Syntax
WORKDAY.INTL(start_date, days, [weekend], [holidays])Square brackets indicate optional arguments.
Arguments
| Argument | Required | Meaning |
|---|---|---|
| start_date | Yes | A date that represents the start date."2008-10-1" |
| days | Yes | The number of nonweekend and nonholiday days before or after start_date. A positive value for days yields a future date; a negative value yields a past date.151 |
| weekend | No | is a weekend number or string that specifies when weekends occur.6 |
| holidays | No | An optional range of one or more dates to exclude from the working calendar, such as state and federal holidays and floating holidays."2008-11-26" |
Try WORKDAY.INTL
Find the next workday after a holiday weekend
=WORKDAY.INTL(A2,1,"0000011",C2)Starting on Friday, one working day later is Tuesday because Saturday/Sunday are weekend days and Monday is a holiday. The starting date itself is not counted as the first added day.
Inspect the current formula
Read its written arguments or observe actual operation values in a separate local calculation. This action neither applies a draft nor grades an answer.
Read the formula, one argument at a time
Explore the written function calls and their inputs. The calculation result belongs to the complete formula.
WORKDAY.INTL · top-level call
=WORKDAY.INTL(A2,1,"0000011",C2)Follow the cells behind a result
Read explicit local references and helper formulas using a separate calculation. Your draft stays in this field; the worksheet and practice checks do not change.
The worksheet runs locally. Published checks apply to the supplied example only. Native Excel and Google Sheets compatibility remain unverified.
Practice a complete task
Reference and compatibility
Univer 1.0.4 / Apache-2.0. Calculation checks cover the supplied examples only. The browser worksheet does not implement every Excel feature, external service or connected data type.