Rational
Find a number of working days between a date range.
Description
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.
Syntax
=NETWORKDAYS (start_date, end_date, [holidays])
Parameters
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.
Return Value
An Integer is representing a count of days.
Key Notes
- 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.
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’.
NETWORKDAYS.INTL
The NETWORKDAYS.INTL counts days between two dates, excl. custom Weekend days. I.e.; workdays between 01-11-2018 (B6) and 31-12-2018 (C6) excl. Friday and Saturday, use =NETWORKDAYS.INTL(B6,C6,7) that returns 43.