Skip to content
ExcelExcel 2010+

WORKDAY.INTL function in Excel

Returns the serial number of the date before or after a specified number of workdays using parameters to indicate which and how many days are weekend days

=WORKDAY.INTL(start_date, days, [weekend], [holidays])

WORKDAY.INTL syntax and parameters

Four arguments, two required.

  • start_dateanyRequired

    The start date, truncated to integer.

  • daysnumberRequired

    The number of workdays before or after the start_date. A positive value yields a future date; a negative value yields a past date; a zero value yields the already specified start_date. Day-offset is truncated to an integer.

  • weekendanyOptional

    If used, this indicates the days of the week that are weekend days and are not considered working days. The weekend argument is a weekend number or string that specifies when weekends occur. The weekend number values indicate weekend days as shown below.

  • holidaysanyOptional

WORKDAY.INTL examples

Formulas you'll actually reuse.

  1. Ten working days on when only Sunday is off (weekend code 11):

    =WORKDAY.INTL(DATE(2026, 9, 1), 10, 11)

    Result2026-09-12

  2. A delivery date from a start date, a lead time in days, a weekend mask and holidays:

    =WORKDAY.INTL(B2, C2, "0000011", H2:H10)

WORKDAY.INTL in Google Sheets

Same name — your formula ports as-is.

Try WORKDAY.INTL in the playground

Edit the example — nothing to install.

Preloaded with the WORKDAY.INTL formula from Example 1 — change anything and watch it respond.

Loading the editor…

WORKDAY.INTL errors

What they mean — and the fixes.

  • #VALUE!

    The weekend string isn't exactly seven 0/1 characters, or the weekend number isn't 1–7 or 11–17.

Related functions

More ways Excel gets this done.