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

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

  1. Ten working days on, Sunday off

    ABC
    1Start
    22026-03-022026-03-13

    In C2: =WORKDAY.INTL(A2, 10, 11) → 2026-03-13

    Try this example

  2. Ten working days on, Saturday and Sunday off

    ABC
    1Start
    22026-03-022026-03-16

    In C2: =WORKDAY.INTL(A2, 10, 1) → 2026-03-16

    Try this example

Common mistakes

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.

Translate a whole formula

Try WORKDAY.INTL in the playground

Related functions