WORKDAY.INTL
Adds business days with custom weekend.
- Excel: Not checked yet
- Google Sheets: Not checked yet
- Returns: Number (date serial)
Examples
=WORKDAY.INTL(DATE(2012,1,1), 90, 11) Result 41013
=WORKDAY.INTL(A1, B1, "0000011", H1:H10) | A | B | C | D | E | F | G | H | |
|---|---|---|---|---|---|---|---|---|
| 1 | 10 | 2 | 2 | |||||
| 2 | 4 |
Result 12
Syntax
WORKDAY.INTL(start_date, days, [weekend], [holidays])start_date- number required
days- number required
weekend- any optional defaults to
1 holidays- any optional