Author: Oscar Cronquist Article last updated on October 19, 2018

The NETWORKDAYS.INTL function calculate the number of working days between two dates, excluding weekends. It also allows you to ignore a list of holiday dates that you can specify. You may specify which days are weekend days.

Formula in cell D3:

=NETWORKDAYS.INTL(B3,C3,"1110011",B6:B7)

Excel Function Syntax

NETWORKDAYS.INTL(start_date, end_date, [weekend], [holidays])

Arguments

start_date Required.
end_date Required.
[weekend] Optional. Allows you to specify which days are weekend days using a number o a string.
[holidays] Optional. Excludes date(s) from being counted.

Weekend numbers

Number Weekend days
1 (default value) 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

You may also specify weekend days using a string containing only 1 and 0 (zero). Example, 1110011 considers only Thursdays and Fridays as workdays, all other days in the week are weekend days.