Skip to content
Excel

NETWORKDAYS function in Excel

Returns the number of whole workdays between two dates

=NETWORKDAYS(start_date, end_date, [holidays])

NETWORKDAYS syntax and parameters

Three arguments, two required.

  • start_dateanyRequired

    A date that represents the start date.

  • end_dateanyRequired

    A date that represents the end date.

  • holidaysanyOptional

    An optional range of one or more dates to exclude from the working calendar, such as state and federal holidays and floating holidays. The list can be either a range of cells that contains the dates or an array constant of the serial numbers that represent the dates.

NETWORKDAYS examples

Formulas you'll actually reuse.

  1. Working days in September 2026, Saturdays and Sundays excluded:

    =NETWORKDAYS(DATE(2026, 9, 1), DATE(2026, 9, 30))

    Result22

  2. Working days of a project, with public holidays listed in H2:H10 skipped too:

    =NETWORKDAYS(B2, C2, H2:H10)

NETWORKDAYS in Google Sheets

Same name — your formula ports as-is.

Try NETWORKDAYS in the playground

Edit the example — nothing to install.

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

Loading the editor…

Related functions

More ways Excel gets this done.