# NETWORKDAY Function

Returns the number of working days between two dates. Adds 1 day to the result if the start date is a non-working day.
Sample Usage
NETWORKDAY([Due Date]4, [Due Date]5)
Syntax
NETWORKDAY(
• 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.
• You can designate additional dates as nonworking to exclude them when calculating the number of working days. To do this, enter each holiday/non-working day into a cell and then reference the range of cells in your NETWORKDAY formula.

Examples

This example references the following sheet information:

Clothing Item Order Date Ship Date Percent Complete
1 T-Shirt 02/12/19 02/15/19 100%
2 Pants 02/15/19 03/20/19 50%
3 Jacket 02/23/19 02/27/19 75%

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

Formula Description Result
=NETWORKDAY([Order Date]2, [Ship Date]2) Returns the number of workdays between the date in the “Order Date” column on row 2 and the date in the “Ship Date” column on row 2. 24
=IF([Clothing Item]3 = "Jacket", NETWORKDAY([Order Date]3, [Ship Date]3)) If the value in the “Clothing Item” column for row 3 is “Jacket”, returns the number of workdays between the date in the “Order Date” column for row 3 and the date in the “Ship Date” column for row 3. Returns no value otherwise. 4
=IF([Percent Complete]1 = 1, NETWORKDAY([Order Date]1, [Ship Date]1), "Order Not Yet Fulfilled") If the value in the “Percent Complete” column for row 1 is 100%, returns the number of workdays between the date in the “Order Date” column for row 1 and the date in the “Ship Date” column for row 1. Returns “Order Not Yet Fulfilled” otherwise. 4