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 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 |
Keep Reading Similar Functions:
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’.
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’.
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”).
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’.
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.
