Excel functions / Date & Time
NETWORKDAYS.INTL function
Working days between two dates, inclusive, with the weekend on days you choose.
Syntax
=NETWORKDAYS.INTL(start_date, end_date, [weekend], [holidays])
Arguments
start_date: The first date.end_date: The last date.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
NETWORKDAYS.INTL counts the working days between two dates, like NETWORKDAYS, but lets you choose which days are the weekend. A number picks a common pattern (7 is Friday and Saturday, 11 is Sunday only), or a text of seven 0s and 1s, Monday first, marks each day off.
Examples
A six-day week, Sunday off
A B C D 1 From To 2 2026-03-02 2026-03-15 12 In D2:
=NETWORKDAYS.INTL(A2, B2, 11)→ 12Working Monday to Thursday only
A B C D 1 From To 2 2026-03-02 2026-03-15 8 In D2:
=NETWORKDAYS.INTL(A2, B2, "0000111")→ 8Each 1 marks a day off, Monday first: Friday, Saturday and Sunday.
Common mistakes
- The pattern text the wrong length. The weekend text must have exactly seven characters, each 0 or 1, starting with Monday.
- Holidays. Public holidays go in a fourth argument, as a range of dates.
NETWORKDAYS.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: NETWORKDAYS.INTL
- Danish: ANTAL.ARBEJDSDAGE.INTL
- Dutch: NETWERKDAGEN.INTL
- Finnish: TYÖPÄIVÄT.KANSVÄL
- French: NB.JOURS.OUVRES.INTL
- German: NETTOARBEITSTAGE.INTL
- Hungarian: ÖSSZ.MUNKANAP.INTL
- Italian: GIORNI.LAVORATIVI.TOT.INTL
- Norwegian: NETT.ARBEIDSDAGER.INTL
- Polish: DNI.ROBOCZE.NIESTAND
- Portuguese (Brazil): DIATRABALHOTOTAL.INTL
- Portuguese (Portugal): DIATRABALHOTOTAL.INTL
- Russian: ЧИСТРАБДНИ.МЕЖД
- Spanish: DIAS.LAB.INTL
- Swedish: NETTOARBETSDAGAR.INT
- Turkish: TAMİŞGÜNÜ.ULUSL
Try NETWORKDAYS.INTL in the playground
Related functions
- NETWORKDAYS: Working days (Monday–Friday) between two dates, inclusive.
- WORKDAY.INTL: The date a number of working days before or after a date, with the weekend on days you choose.
- WORKDAY: The date a number of working days before or after a date.
- WEEKDAY: The day of the week as a number.