NETWORKDAY Function

Returns the number of working days between two dates. Adds 1 day to the result if the start date is a nonworking day.
Sample Usage
NETWORKDAY([Due Date]4, [Due Date]5)
Syntax
NETWORKDAY(
  • 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 nonworking days. If dependencies are enabled on your sheet, you can customize the nonworking days. After you do this, 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/nonworking day into a cell. Then reference the range of cells in your NETWORKDAY formula.
     
Examples

This example references the following sheet information:

  Clothing Item Order Date Ship Date Percent Complete
1 T-Shirt 02/12/19 02/15/19 100%
2 Pants 02/15/19 03/20/19 50%
3 Jacket 02/23/19 02/27/19 75%

Given the table above, here are some examples of using NETWORKDAY in a sheet:

Formula Description Result
=NETWORKDAY([Order Date]2, [Ship Date]2) Returns the number of workdays 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", NETWORKDAY([Order Date]3, [Ship Date]3)) If the value in row 2 of the Clothing Item column is Jacket, the function returns the number of workdays between the date in row 3 of the Order Date column  and the date in row 3 of the Ship Date column. Otherwise, the function returns no value. 4
=IF([Percent Complete]1 = 1, NETWORKDAY([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 workdays 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

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.

Ask the Community