NETWORKDAYS.INTL

Find a number of working days with custom weekend days in Excel
Returns the number of whole workdays between two dates (international version).

Rational

Find a number of working days with custom weekend days.

Description

The Excel NETWORKDAYS.INTL counts the number of days between two dates, excluding custom Weekend days. Example; to get workdays between 01-11-2018 (B6) and 31-12-2018 (C6) excluding Friday and Saturday, use =NETWORKDAYS.INTL(B6,C6,7) that returns ‘43’.
Moreover, an optional argument (holidays) can also exclude holidays, vacation time, and so on.

Syntax

=NETWORKDAYS.INTL(start_date, end_date, [weekend], [holidays])

Parameters

start_date – First date or string of a date
end_date – Second date or string of a date
weekend [optional] – Setting custom weekend days
holidays [optional] – A list of additional days to be excluded apart from weekends.

Return Value

An Integer representing a count of days

Key Notes

The NETWORKDAYS.INTL function calculates the difference between two given dates, excluding custom weekend days (default is Saturdays and Sundays).
Although optional the user can also specify the list of holidays to be excluded from the result.
The NETWORKDAYS.INTL function was introduced in the Excel 2010 providing a higher degree of freedom compared to NETWORKDAYS formula. The update formula is useful to consider weekend days other than Saturday and Sunday.
If start_date or end_date is out of range, NETWORKDAYS.INTL returns the #NUM! error value. The weekend is an optional argument to select customize weekend number or string that specifies when a weekend occurs in a week to excel.

Weekend number value indicates the following weekend days:

Weekend
number
Weekend days
1 or omittedSaturday, Sunday
2Sunday, Monday
3Monday, Tuesday
4Tuesday, Wednesday
5Wednesday, Thursday
6Thursday, Friday
7Friday, Saturday
11Sunday only
12Monday only
13Tuesday only
14Wednesday only
15Thursday only
16Friday only
17Saturday only

Keep Reading Similar Functions:

Find the difference between two dates, based on a 360 days year cycle in Excel.

DAYS360

The Excel DAYS360 function result assumes that a Year is of 360 days, 30 days per month.
use =DAYS360(“01/05/2017”, “01/08/2018”) that returns ‘450’.

Read More »
Find the difference between two dates in Excel

DAYS

The DAYS function returns the difference between two dates. To find days duration between two dates, use DAYS(“01/08/2018″,”01/05/2017”) that returns ‘457’.

Read More »
Determine the difference between two dates in Excel

DATEDIF

The DATEDIF is an unknown compatibility function that can be used to calculate the difference between two dates. To find years diff.,=DATEDIF(start_date, end_date,”y”).

Read More »
Find a number of working days between a date range in Excel

NETWORKDAYS

The NETWORKDAYS function returns a number of working days between two dates, 01-11-2018 (B6) and 31-12-2018 (C6), use =NETWORKDAYS(B6,C6) that returns ‘43’.

Read More »
Get Nth working day before and after a given date in Excel

WORKDAY

WORKDAY function returns a date based on a given number of working days before and after starting date, to find two days after a date excl. weekends,=WORKDAY(date,2) returns 2.

Read More »