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
Sample usage
NETWORKDAYS([Due Date]4, [Due Date]5, [holidays])
Usage notes
WORKDAY, NETWORKDAY, and NETWORKDAYS count Saturday and Sunday as non-working days. If you enable dependencies on your sheet, you can customize the non-working days. After you do this, the formulas use your settings in calculations.
Examples
This example references the following sheet information:
Clothing Item | Order Date | Ship Date | Holiday | Percent Complete | |
---|---|---|---|---|---|
1 | Clothing Item T-Shirt | Order Date 02/12/19 | Ship Date 02/15/19 | Holiday | Percent Complete 100% |
2 | Clothing Item Pants | Order Date 02/15/19 | Ship Date 03/20/19 | Holiday 2/21/19 | Percent Complete 50% |
3 | Clothing Item Jacket | Order Date 02/20/19 | Ship Date 02/27/19 | Holiday 2/21/19 | Percent Complete 75% |
Given the table above, here are some examples of using NETWORKDAYS in a sheet:
Formula | Description | Result |
---|---|---|
Formula =IF([Percent Complete]1 = 1, NETWORKDAYS([Order Date]1, [Ship Date]1), "Order Not Yet Fulfilled") | Description If the value in row 1 of the Percent Complete column is 100%, the function returns the number of working days between the date in row 1 of the Order Date column and the date in row 1 of the Ship Date column. Otherwise, the function returns Order Not Yet Fulfilled. | Result 4 |
Formula =NETWORKDAYS([Order Date]2, [Ship Date]2) | Description Returns the number of working days between the date in row 2 of the Order Date column and the date in row 2 of the Ship Date column. | Result 24 |
Formula =IF([Clothing Item]3 = "Jacket", NETWORKDAYS([Order Date]3, [Ship Date]3)) | Description If the value in row 3 of the Clothing Item column is Jacket, the return the number of working days between the date in row 3 of the Order Date column and the date in row 3 of the Ship Date column. Otherwise, keep the cell blank. | Result 6 |
Formula =NETWORKDAYS([Order Date]2, [Ship Date]2, Holiday2) | Description Returns the number of working days—excluding the holidays—between the Order Date and Ship Date columns in row 2. | Result 23 |
Still need help?
Use the Formula Handbook template to find more support resources, and view 100+ formulas, including a glossary of every function that you can practice working with in real time, and examples of commonly used and advanced formulas.
Find examples of how other Smartsheet customers use this function or ask about your specific use case in the Smartsheet online Community.