NETWORKDAYS.INTL
Description
Returns the number of work days between two specified dates. The start_date and end_date are included in the result. Similar to NETWORKDAYS(), but in NETWORKDAYS.INTL() you can specify which days of the week are weekend days.
Syntax
NETWORKDAYS.INTL(
start_date
,
end_date
, [
weekend
], [
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.
- weekend: The code specifying which days of the week are weekend days. The code can be numerical, as described in the table below, or a string, where a 0 represents a weekday and a 1 represents a weekend day. Example: "0000111" specifies that Friday, Saturday, and Sunday are weekend days.
- holidays: The list of dates to exclude from the work day count.
Code | Description |
|---|---|
1 | Saturday and Sunday |
2 | Sunday and Monday |
3 | Monday and Tuesday |
4 | Tuesday and Wednesday |
5 | Wednesday and Thursday |
6 | Thursday and Friday |
7 | Friday and Saturday |
11 | Sunday only |
12 | Monday only |
13 | Tuesday only |
14 | Wednesday only |
15 | Thursday only |
16 | Friday only |
17 | Saturday only |
Example
Formula | Result |
|---|---|
=NETWORKDAYS.INTL("11/20/2017","12/31/2017") | 30 |
=NETWORKDAYS.INTL("11/20/2017","12/31/2017",1,{"11/23/2017",
"11/24/2017", "12/25/2017"}) | 27 |
=NETWORKDAYS.INTL("11/20/2017","12/31/2017","0000100",{"11/23/2017",
"11/24/2017", "12/25/2017"}) | 34 |