Returns the number of working days between two dates. Adds 1 day to the result if the start date is a non-working day.
NETWORKDAY([Due Date]4, [Due Date]5)
- 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.
- 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.
This example references the following sheet information:
|Clothing Item||Order Date||Ship Date||% Complete|
Given the table above, here are some examples of using NETWORKDAY in a sheet:
|=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|