Returns the number of working days between two dates.
Sample Usage
NETWORKDAYS([Due Date]4, [Due Date]5, [holidays])
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 Item | Order Date | Ship Date | Holiday | Percent Complete | |
|---|---|---|---|---|---|
| 1 | t恤 | 02/12/19 | 02/15/19 | 100% | |
| 2 | Pants | 02/15/19 | 03/20/19 | 2/21/19 | 50% |
| 3 | Jacket | 02/20/19 | 02/27/19 | 2/21/19 | 75% |
Given the table above, here are some examples of using NETWORKDAYS in a sheet:
| Formula | Description | Result |
|---|---|---|
| =IF([Percent Complete]1 = 1, NETWORKDAYS([Order Date]1, [Ship Date]1), "Order Not Yet Fulfilled") | If the value in row 1 of thePercent Completecolumn is100%, the function returns the number of working days between the date in row 1 of theOrder Datecolumn and the date in row 1 of theShip Date列。Otherwise, the function returnsOrder Not Yet Fulfilled. | 4 |
| =NETWORKDAYS([Order Date]2, [Ship Date]2) | Returns the number of working days between the date in row 2 of theOrder Datecolumn and the date in row 2 of theShip Date列。 | 24 |
| =IF([Clothing Item]3 = "Jacket", NETWORKDAYS([Order Date]3, [Ship Date]3)) | If the value in row 3 of theClothing Itemcolumn isJacket, the return the number of working days between the date in row 3 of theOrder Datecolumn and the date in row 3 of theShip Date列。Otherwise, keep the cell blank. | 6 |
| =NETWORKDAYS([Order Date]2, [Ship Date]2, Holiday2) | Returns the number of working days—excluding the holidays—between theOrder DateandShip Datecolumns in row 2. | 23 |
Still need help?
Use theFormula Handbook templateto 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.