NETWORKDAYS Function

Returns the number of working days between two dates.
Sample Usage
NETWORKDAYS([Due Date]4, [Due Date]5)
Syntax
NETWORKDAYS(
  • start_date
  • end_date
  • [
    holidays
    ]
)
  • start_date
    The first date to be measured.
  • end_date
    The last date to be measured.
  • holidays
    —[optional]
    The dates to exclude from the count.
Usage Notes
  • WORKDAY, NETWORKDAY, and NETWORKDAYS count Saturday and Sunday as non-working days. If dependencies are enabled on your sheet you can customize the non-working days, and the formulas will use your settings in calculations.
Examples

This example references the following sheet information:

 Clothing ItemOrder DateShip Date% Complete
1T-Shirt02/12/1902/15/19100%
2Pants02/15/1903/20/1950%
3Jacket02/20/1902/27/1975%

Given the table above, here are some examples of using NETWORKDAYS in a sheet:

FormulaDescriptionResult
=IF([% Complete]1 = 1, NETWORKDAYS([Order Date]1, [Ship Date]1), "Order Not Yet Fulfilled")If the value in the “% Complete” column for row 1 is 100%, return the number of working days between the date in the “Order Date” column for row 1 and the date in the “Ship Date” column for row 1, if not return “Order Not Yet Fulfilled."4
=NETWORKDAYS([Order Date]2, [Ship Date]2)Returns the number of working days between the date in the “Order Date” column for row 2 and the date in the “Ship Date” column for row 2.24
=IF([Clothing Item]3 = "Jacket", NETWORKDAYS([Order Date]3, [Ship Date]3))If the value in the “Clothing Item” column for row 3 is “Jacket”, return the number of working days between the date in the “Order Date” column for row 3 and the date in the “Ship Date” column for row 3, if not keep the cell blank.6
Was this article helpful?
YesNo