WORKDAY.INTL
adds business days with custom weekend · from excel · excel: not yet compared · sheets: not yet compared
signature
WORKDAY.INTL(start_date, days, [weekend], [holidays])
returns: number (date serial)
| argument | required |
|---|---|
| start_date | required |
| days | required |
| weekend | optional · defaults to 1 |
| holidays | optional |
examples
formula and result, taken from the engine's own test suite — every result below is asserted in CI, not written by hand.
fx
=WORKDAY.INTL(DATE(2012,1,1), 90, 11) 41013 | A | B | C | D | E | F | G | H | |
|---|---|---|---|---|---|---|---|---|
| 1 | 10 | 2 | 2 | |||||
| 2 | 4 |
fx
=WORKDAY.INTL(A1, B1, "0000011", H1:H10) 12