Returns the number of workdays between a start date and an end date. There are options to define weekend days and holidays. The optional weekend parameter (or a string) can be used to define the weekend days (or the non-working days in each week). Also, optionally, the user can define a holiday list. The weekend days and user-defined holidays are not counted as working days.
NETWORKDAYS.INTL(StartDate; EndDate; Weekend; Holidays)
StartDate is the date from when the calculation is carried out. If the start date is a workday, the day is included in the calculation.
EndDate is the date up until when the calculation is carried out. If the end date is a workday, the day is included in the calculation.
How many workdays fall between December 15, 2016 and January 14, 2017? Let the start date be located in C3 and the end date in D3. Cells F3 to J3 contain five (5) holidays for Christmas and New Year in date format: December 24, 2016; December 25, 2016; December 26, 2016; December 31, 2016; and January 1, 2017.
=NETWORKDAYS.INTL(C3;D3;;F3:J3) returns 21 workdays with default for weekend days.
=NETWORKDAYS.INTL(C3;D3;11;F3:J3) returns 24 workdays with Sunday only weekends.
Alternatively, use the weekend string “0000001” to define Sunday as the non-working day of every week.
=NETWORKDAYS.INTL(C3;D3;“0000001”;F3:J3) returns 24 workdays with Sunday only weekend.
The function can be used without the two optional parameters – weekday and holidays – by leaving them out:
=NETWORKDAYS.INTL(C3;D3) gives 22 working days.