NETWORKDAYS.INTL
Category: DateTime Function.
Description: Returns the number of whole workdays between two dates using parameters to indicate which and how many days are weekend days.
Syntax: NETWORKDAYS.INTL(start_date, end_date, weekend, holidays)
Start_date and end_date are required.
They are the dates for which the difference is to be computed.
Weekend parameter is optional.
It indicates the days of the week that are weekend days and are not included in the number of whole working days.
Weekend is a weekend number or string that specifies when weekends occur.
Weekend numbers are listed in the following table.
|
Weekend number
|
Weekend Days
|
|
1 or omitted
|
Saturday, Sunday
|
|
2
|
Sunday, Monday
|
|
3
|
Monday, Tuesday
|
|
4
|
Tuesday, Wednesday
|
|
5
|
Wednesday, Thursday
|
|
6
|
Thursday, Friday
|
|
7
|
Friday, Saturday
|
|
11
|
Sunday only
|
|
12
|
Monday only
|
|
13
|
Tuesday only
|
|
14
|
Wednesday only
|
|
15
|
Thursday only
|
|
16
|
Friday only
|
|
17
|
Saturday only
|
Weekend string values are seven characters long and each character in the string represents a day of the week, starting with Monday.
1 represents a non-workday and 0 represents a workday.
Only the characters 1 and 0 are permitted in the string.
For example, 0000110 would result in a weekend that is Friday and Saturday.
Holidays is the optional parameter.
It is one or more dates that are to be excluded from the working days.
Holidays should be a range of cells containing dates, or an array of the serial values.