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

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

  1. A six-day week, Sunday off

    ABCD
    1FromTo
    22026-03-022026-03-1512

    In D2: =NETWORKDAYS.INTL(A2, B2, 11) → 12

    Try this example

  2. Working Monday to Thursday only

    ABCD
    1FromTo
    22026-03-022026-03-158

    In D2: =NETWORKDAYS.INTL(A2, B2, "0000111") → 8

    Each 1 marks a day off, Monday first: Friday, Saturday and Sunday.

    Try this example

Common mistakes

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.

Translate a whole formula

Try NETWORKDAYS.INTL in the playground

Related functions