NETWORKDAYS Function | Smartsheet Learning Center

Returns the number of working days between two dates.

Sample Usage

NETWORKDAYS([Due Date]4, [Due Date]5)

Syntax

NETWORKDAYS(

)

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	% Complete
1	T-Shirt	02/12/19	02/15/19	100%
2	Pants	02/15/19	03/20/19	50%
3	Jacket	02/20/19	02/27/19	75%

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

Formula	Description	Result
=IF( <?php Complete]1 = 1, NETWORKDAYS([Order Date]1, [Ship Date]1), "Order Not Yet Fulfilled")</td> <td>If the value in the “% Complete” column for row 1 is 100%, return the number of working days between the date in the “Order Date” column for row 1 and the date in the “Ship Date” column for row 1, if not return “Order Not Yet Fulfilled."</td> <td>4</td> </tr> <tr> <td>=NETWORKDAYS([Order Date]2, [Ship Date]2)</td> <td>Returns the number of working days between the date in the “Order Date” column for row 2 and the date in the “Ship Date” column for row 2.</td> <td>24</td> </tr> <tr> <td>=IF([Clothing Item]3 = "Jacket", NETWORKDAYS([Order Date]3, [Ship Date]3))</td> <td>If the value in the “Clothing Item” column for row 3 is “Jacket”, return the number of working days between the date in the “Order Date” column for row 3 and the date in the “Ship Date” column for row 3, if not keep the cell blank.</td> <td>6</td> </tr> </tbody> </table>?>