Syntax:
NETWORKDAYS.INTL(StartDate; EndDate [; Weekend] [; Holidays])
Description:
This returns the number of workdays between StartDate and EndDate. This function counts workdays only by default and Saturdays and Sundays are skipped.
You have the option of entering weekend parameters to define exactly which weekdays should be skipped. You also have the option of specifying a list of holidays. These will also be skipped.
Note: NETWORKDAYS.INTL is a more flexible variant of the NETWORKDAYS function, as the weekend parameter can be defined individually.
StartDate and EndDate are the first and the last day of the time interval to be evaluated.
For Weekend, you have the option of setting which weekdays are considered weekends. If omitted, the default value 1 is used (Saturday, Sunday). See the lists below with all available parameters.
Holidays (optional) is a cell range or an array containing a list of dates to be skipped (for example, holidays). (This is usually done using a cell range or an array containing the corresponding date values.)
Value |
Weekend |
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 |
An even more flexible method of defining weekends is a 7-digit string of ones and zeros. Each character in the 7-digit string stands for a day of the week: the first character stands for Monday, the second for Tuesday, etc. The 0 represents a normal work day and the 1 represents a weekend day.
7-digit examples |
Weekend |
0000000 |
Without weekend |
1000000 |
Monday free |
0100000 |
Tuesday free |
0110000 |
Tuesday, Wednesday free |
0010110 |
Wednesday, Friday, Saturday free |
Example:
Calendar sheet January 2021 (for better orientation)
NETWORKDAYS.INTL("1/1/2021", "1/31/2021") returns 21.
January 2021 thus had 21 work days (not including holidays).
NETWORKDAYS.INTL("1/1/2021", "1/31/2021", 17) returns 26, as only Saturday (parameter value = 17) was specified as a weekend.
With the 7-digit string, the same formula would look like this:
NETWORKDAYS.INTL("1/1/2021", "1/31/2021", "0000010") returns 26.
If you want to include the holidays on 1/1/2021 and 1/6/2021 (in most European countries), you can enter these two dates in cells A1 and B1, for example, and then write them as follows:
NETWORKDAYS.INTL("1/1/2021", "1/31/2021", 1, A1:B1) – and this results in 19. For the weekend days, the default value (1 = Saturday, Sunday) was used here again.
See also:
NETWORKDAYS, WORKDAY, WORKDAY.INTL,DAYS/DAYSP, DAYS360, DATEDIF, HOLIDAY