Skip to content
Google Sheets

NETWORKDAYS function in Google Sheets

Returns the number of net working days between two provided days.

=NETWORKDAYS(start_date, end_date, [holidays])

NETWORKDAYS syntax and parameters

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

  • holidaysanyOptional

    [ OPTIONAL ] - A range or array constant containing the date serial numbers to consider 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 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 Excel

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