The NETWORKDAYS.INTL calculates the number of working days between two dates. The function excludes weekends (which may or may not be Saturday and Sunday) and can exclude holidays if you provide a list.
Syntax
=NETWORKDAYS.INTL(start_date,end_date,[weekend day(s)],[holiday(s)])
start_date
Date at which to start the calculation
end_date
Date at which to end the calculation
[weekend day(s)]
An optional description of which days are weekends.
 Number method
 1 – Saturday and Sunday [don’t need to specify]
 2 – Sunday and Monday
 3 – Monday and Tuesday
 4 – Tuesday and Wednesday
 5 – Wednesday and Thursday
 6 – Thursday and Friday
 7 – Friday and Saturday
 11 – Sunday only
 12 – Monday only
 13 – Tuesday only
 14 – Wednesday only
 15 – Thursday only
 16 – Friday only
 17 – Saturday only
 String method – Each digit represents a day. First digit is Monday.

 0000011 – Saturday and Sunday
 0100000 – Only Tuesday
[holiday(s)]
An optional list of holidays to exclude from the count of days.
Related functions
DAYS – Calculate the number of days between two dates.
DATEDIF – Calculate length of time between two dates in years, months, and/or days.
MINUS – Subtract one value from another. Can be done with dates.
NETWORKDAYS – Calculate the number of working days without the weekend modifications of NETWORKDAYS.INTL
Errors
#VALUE! – The inputs are something that isn’t a valid date such as “The other day” or “Yesteryesterday”.
Examples
Live examples in Sheets
Go to this spreadsheet for the examples of the NETWORKDAYS.INTL function shown above that you can study and use anywhere you would like.