Find a number of working days between a date range.
The Excel NETWORKDAYS function (net workdays) returns a number of working days between two given dates. Example; to get workdays between 01-11-2018 (B6) and 31-12-2018 (C6) without Weekends, use =NETWORKDAYS(B6,C6) that returns ‘43’.
It counts the number of days between two dates, excluding Saturdays and Sundays falling within the specified date range and as an optional argument function can also exclude holidays, vacation time, and so on.
=NETWORKDAYS (start_date, end_date, [holidays])
start_date – First date or string of a date.
end_date – Second date or string of a date
holidays [optional] – A list of additional days to exclude apart from weekends.
An Integer is representing a count of days.
- The NETWORKDAYS function counts the difference between two given dates, after automatically excluding weekend days (Saturdays and Sundays).
- Use NETWORKDAYS.INTL finds difference after excluding custom weekend days or DAYS function to calculate days difference irrespective of working days.
- Although optional, you can also specify a list of holidays to exclude from the result.
- NETWORKDAYS function can be used to find the number of days an invoice is past due excluding weekends and holidays, count of working days left in the year, employee benefits often based on the number of working days, and so on.