Skip to content
Google Sheets

NETWORKDAYS.INTL function in Google Sheets

Returns the number of net working days between two provided days excluding specified weekend days and holidays.

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

NETWORKDAYS.INTL syntax and parameters

Four arguments, two required.

  • start_dateanyRequired

    The start date of the period from which to calculate the number of net working days.

  • end_dateanyRequired

    The end date of the period from which to calculate the number of net working days.

  • weekendanyOptional

    [ OPTIONAL - 1 by default ] - A number or string representing which days of the week are considered weekends. String method: weekends can be specified using seven 0’s and 1’s, where the first number in the set represents Monday and the last number is for Sunday. A zero means that the day is a work day, a 1 means that the day is a weekend. For example, “0000011” would mean Saturday and Sunday are weekends. Number method: instead of using the string method above, a single number can be used. 1 = Saturday/Sunday are weekends, 2 = Sunday/Monday, and this pattern repeats until 7 = Friday/Saturday. 11 = Sunday is the only weekend, 12 = Monday is the only weekend, and this pattern repeats until 17 = Saturday is the only weekend.

  • holidaysanyOptional

    [ OPTIONAL ] - A range or array constant containing the dates to consider as holidays. The values provided within an array for holidays must be date serial number values, as returned by N or date values, as returned by DATE, DATEVALUE or TO_DATE. Values specified by a range should be standard date values or date serial numbers.

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 Excel

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 Google Sheets gets this done.