Menu
EXCEL NETWORKDAYS.INTL FUNCTION
Excel NETWORKDAYS.INTL Function Introduction
This function returns the number of days that have passed between two dates, except weekends (which are defaulted to Saturday and Sunday). Because you can specify which days of the week are designated as weekends, this function is more adaptable than the NETWORKDAYS function. For example, you can declare any day (such as Monday or Tuesday) or any two days (such as Tuesday and Wednesday or Wednesday and Thursday) a weekend.
You can also add holidays as a fourth parameter to exclude weekends from the number of days calculation. Excel 2010 included this feature.
Description of Excel NETWORKDAYS.INTL Function
Syntax:
=NETWORKDAYS.INTL (start_date, end_date, [weekend], [holidays])
Parameter list:
- start date – the start date;
- end date – the end date
- Weekend – Sets which days of the week should be considered weekends (optional).
- holidays – [optional] a list of dates that should be treated as non-working days.
Step By Step Guide of NETWORKDAYS.INTL Function
The weekend numbers (fourth parameter) are listed below.
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
Key Points
- The method produces a negative number when start date is greater than end date.
- NETWORKDAYS is used when start date or end date are out of range.
- The error #NUM! is returned by INTL.
- NETWORKDAYS will be used if the weekend is not available.
- THE #VALUE! error is returned by INTL.
Related Functions
HLOOKUP Function
HLOOKUP Function
Explore NowVLOOKUP Function
VLOOKUP Function
Explore NowINDEX Function
INDEX Function
Explore NowMATCH Function
MATCH Function
Explore NowDATE Function
DATE Function
Explore NowIF Function
IF Function
Explore NowOR Function
OR Function
Explore NowAND Function
AND Function
Explore NowRANK Function
RANK Function
Explore NowSUMIF Function
SUMIF Function
Explore NowXIRR Function
XIRR Function
Explore NowWORKDAYS Function
WORKDAYS Function
Explore Now
