Excel functions / Date & Time
WORKDAY.INTL function
The date a number of working days before or after a date, with the weekend on days you choose.
Syntax
=WORKDAY.INTL(start_date, days, [weekend], [holidays])
Arguments
start_date: The starting date.days: Working days to add (negative to go back).weekend(optional): Which days are the weekend. 1 (default) = Sat–Sun, 2 = Sun–Mon … 7 = Fri–Sat; 11 = Sunday only … 17 = Saturday only; or seven 0s and 1s from Monday, such as "0000011".holidays(optional): Dates to skip.
When to use it
WORKDAY.INTL gives the date a number of working days after (or before) a start date, skipping weekends you choose and any holidays you list. WORKDAY assumes Saturday and Sunday off; this one takes the same weekend patterns as NETWORKDAYS.INTL.
Examples
Ten working days on, Sunday off
A B C 1 Start 2 2026-03-02 2026-03-13 In C2:
=WORKDAY.INTL(A2, 10, 11)→ 2026-03-13Ten working days on, Saturday and Sunday off
A B C 1 Start 2 2026-03-02 2026-03-16 In C2:
=WORKDAY.INTL(A2, 10, 1)→ 2026-03-16
Common mistakes
- The result shows as a number. The result is a date serial number. Format the cell as a date.
- Counting the start day. The start date itself is not counted: one working day after a Monday is Tuesday.
WORKDAY.INTL in other languages
Excel shows function names in its own language. In these languages it also puts a semicolon between arguments where English has a comma.
- Czech: WORKDAY.INTL
- Danish: ARBEJDSDAG.INTL
- Dutch: WERKDAG.INTL
- Finnish: TYÖPÄIVÄ.KANSVÄL
- French: SERIE.JOUR.OUVRE.INTL
- German: ARBEITSTAG.INTL
- Hungarian: KALK.MUNKANAP.INTL
- Italian: GIORNO.LAVORATIVO.INTL
- Norwegian: ARBEIDSDAG.INTL
- Polish: DZIEŃ.ROBOCZY.NIESTAND
- Portuguese (Brazil): DIATRABALHO.INTL
- Portuguese (Portugal): DIATRABALHO.INTL
- Russian: РАБДЕНЬ.МЕЖД
- Spanish: DIA.LAB.INTL
- Swedish: ARBETSDAGAR.INT
- Turkish: İŞGÜNÜ.ULUSL
Try WORKDAY.INTL in the playground
Related functions
- WORKDAY: The date a number of working days before or after a date.
- NETWORKDAYS.INTL: Working days between two dates, inclusive, with the weekend on days you choose.
- EDATE: The same day a number of months before or after a date.
- WEEKDAY: The day of the week as a number.