Find a number of working days with custom weekend days.
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.
=NETWORKDAYS.INTL(start_date, end_date, [weekend], [holidays])
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.
An Integer representing a count of days
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:
|1 or omitted||Saturday, Sunday|