- 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.
This example references the following sheet information:
|Clothing Item||Order Date||Ship Date||Percent Complete|
Given the table above, here are some examples of using NETWORKDAYS in a sheet:
|=IF([Percent Complete]1 = 1, NETWORKDAYS([Order Date]1, [Ship Date]1), "Order Not Yet Fulfilled")||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.||4|
|=NETWORKDAYS([Order Date]2, [Ship Date]2)||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.||24|
|=IF([Clothing Item]3 = "Jacket", NETWORKDAYS([Order Date]3, [Ship Date]3))||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.||6|
Still need help?
Use the Smartsheet Formula Template to view examples and practice working with functions in real-time.
Find examples of how other Smartsheet customers use this function or ask about your specific use case in the Smartsheet online Community.