Exceljet

Quick, clean, and to the point

Excel NETWORKDAYS.INTL Function

Excel NETWORKDAYS.INTL function
Summary 

The Excel NETWORKDAYS.INTL function calculates the number of working days between two dates. NETWORKDAYS.INTL excludes Saturday and Sunday by default, but provides a way to specify which days of the week are considered weekends.  The function can optionally exclude a list of holidays supplied as dates. 

Purpose 
Get work days between two dates
Return value 
A number representing days.
Syntax 
=NETWORKDAYS.INTL (start_date, end_date, [weekend], [holidays])
Arguments 
  • start_date - The start date.
  • end_date - The end date.
  • weekend - [optional] Setting for which days of the week should be considered weekends.
  • holidays - [optional] A reference to dates that should be considered non-work days.
Usage notes 

NETWORKDAYS.INTL calculates work days between two dates. Work days exclude weekends (Saturday and Sunday by default) and can optionally exclude holidays. This function is more robust that the NETWORKDAYS function, because it allows you to control which days of the week are considered weekends. The weekend argument is set using the codes listed in the table below.

NETWORKDAYS.INTL can also optionally take into account holidays. For the holidays argument, supply a range that contains holiday dates. These are also treated as non-working days and will not be included in the result.

In the example shown, the following formulas are used:

D4=NETWORKDAYS.INTL(B4,C4)
D5=NETWORKDAYS.INTL(B5,C5,17)
D6=NETWORKDAYS.INTL(B6,C6,1,B9:B10)
Weekend number Weekend days
1 (default) 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

Notes:

  • If start_date is greater than end_date, the the function returns a negative value.
  • If start_date or end_date are out of range, NETWORKDAYS.INTL returns the #NUM! error.
  • If weekend is invalid, NETWORKDAYS.INTL returns the #VALUE! error.

Excel Formula Training

Learn Excel formulas and functions with concise, clear videos. Master absolute/relative addresses, dates, text, named ranges, and tools for troubleshooting. Each video comes with a practice worksheet and audio transcript. Instant access and complete 100% guarantee. Start today!

See details.

Thank you for all the tips/tricks I received, they are very helpful. -Xin
Excel foundational video course
Excel Pivot Table video training course
Excel conditional formatting video course
Excel formulas and functions video training course
Excel Shortcuts Video Course