NETWORKDAYS.INTL

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

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.