Returns the number of days from a start date to an end date
Sample Usage
NETDAYS([Due Date]4, [Due Date]5)
Syntax
NETDAYS(
-
start_date
-
end_date
-
start_date—The first date that you want to be measured
-
end_date—The last date that you want to be measured
Examples
This example references the following sheet information:
| Clothing Item | Transaction Total | Units Sold | 销售日期 | |
|---|---|---|---|---|
| 1 | t恤 | 1,170.00 | 78 | 02/12/19 |
| 2 | Pants | 1,491.00 | 42 | 02/15/19 |
| 3 | Jacket | 812.00 | 217 | 02/20/19 |
Given the table above, here are some examples of using NETDAYS in a sheet:
| Formula | Description | Result |
|---|---|---|
| =NETDAYS([Sold Date]1, [Sold Date]2) | Returns the number of days from the start date in row 1 of the销售日期column on to the end date in row 2 of the销售日期column | 4 |
| =NETDAYS(MAX([Sold Date]:[Sold Date]), TODAY()) | Returns the number of days from the most recent date in the销售日期column to the current date. The current date in this example beingMay 31st, 2019. Note that the TODAY function updates as the current date change. |
101 |
| =NETDAYS(MIN([Sold Date]:[Sold Date]), MAX([Sold Date]:[Sold Date])) | Returns the number of days from the oldest date in the销售日期column, to the most recent date in the销售日期column | 9 |
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.