NETWORKDAYS
Description
Returns the number of work days between two specified dates. The start_date and end_date are included in the result.
Syntax
NETWORKDAYS(
start_date
,
end_date
, [
holidays
])
- start_date: The starting date for the count. Workday recommends using a cell reference to specify the date instead of entering the date as text, to ensure reliable results.
- end_date: The ending date for the count. Workday recommends using a cell reference to specify the date instead of entering the date as text, to ensure reliable results.
- holidays: The list of dates to exclude from the work day count.
Example
Formula | Result |
|---|---|
=NETWORKDAYS("11/23/2017","12/31/2017") | 30 |
=NETWORKDAYS("11/23/2017","12/31/2017",{"11/27/2016", "12/1/2016",
"12/25/2016"}) | 27 |