Returns the number of working days between two dates.
Sample Usage
NETWORKDAYS([Due Date]4, [Due Date]5)
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 | Percent 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([Percent Complete]1 = 1, NETWORKDAYS([Order Date]1, [Ship Date]1), "Order Not Yet Fulfilled") | If the value in the “Percent 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." | 4 |
| =NETWORKDAYS([Order Date]2, [Ship Date]2) | 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. | 24 |
| =IF([Clothing Item]3 = "Jacket", NETWORKDAYS([Order Date]3, [Ship Date]3)) | 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. | 6 |