NETWORKDAYS.INTL takes fourarguments:start_date,end_date,weekend, andholidays.
Thestart_date,end_dateandholidaysarguments must bevalid Excel dates.
Theweekendargument controls which days of the week are considered weekends, and therefore not included in the count.
Holidays are also treated as non-working days and will not be included in the result.
Both the weekend and holidays arguments are optional.
By default, NETWORKDAYS.INTL will exclude Saturdays and Sundays, but this can be customized as explained below.
To exclude holidays, supply a range that contains non-working dates for theholidayargument.
Result 2 in column D shows the effect of excluding holidays from the working day count.
Result 3 shows how the NETWORKDAYS.INTL function can be configured to define custom weekends.
See below for more detail on configuring weekends.
Configuring weekends
The NETWORKDAYS.INTL function provides two options to configure weekends.
The first option is to supply a number as shown in the table below.
The second way to configure weekends is to provide atext stringcomposed of 1s and 0s.
This text is provided as a string of 7 characters which must be either 1 or 0.
In this scheme, the number 1 means weekend and 0 means workday.
Each character represents a different day of the week, starting with the first character as Monday.
NETWORKDAYS automatically excludes weekends (Saturday and Sunday) and canoptionallyexclude a list of holidays supplied as dates.
