Skip to content
ExcelExcel 2010+

NETWORKDAYS.INTL function in Excel

Returns the number of whole workdays between two dates using parameters to indicate which and how many days are weekend days

=NETWORKDAYS.INTL(start_date, end_date, [weekend], [holidays])

NETWORKDAYS.INTL syntax and parameters

Four arguments, two required.

  • start_dateanyRequired
  • end_dateanyRequired
  • weekendanyOptional

    Indicates the days of the week that are weekend days and are not included in the number of whole working days between start_date and end_date. Weekend is a weekend number or string that specifies when weekends occur. Weekend number values indicate the following weekend days:

  • holidaysanyOptional

    An optional set of one or more dates that are to be excluded from the working day calendar. Holidays shall be a range of cells that contain the dates, or an array constant of the serial values that represent those dates. The ordering of dates or serial values in holidays can be arbitrary.

NETWORKDAYS.INTL examples

Formulas you'll actually reuse.

  1. Working days when only Sunday is off (weekend code 11):

    =NETWORKDAYS.INTL(DATE(2026, 9, 1), DATE(2026, 9, 30), 11)

    Result26

  2. A Friday–Saturday weekend as a 7-character mask (1 = off, Monday first), plus holidays:

    =NETWORKDAYS.INTL(DATE(2026, 9, 1), DATE(2026, 9, 30), "0000110", H2:H10)

NETWORKDAYS.INTL in Google Sheets

Same name — your formula ports as-is.

Try NETWORKDAYS.INTL in the playground

Edit the example — nothing to install.

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

Loading the editor…

NETWORKDAYS.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.