NETWORKDAYS

Find a number of working days between a date range in Excel
Returns the number of whole workdays between two dates.

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:

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 »
Find a number of working days with custom weekend days in Excel

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.

Read More »