The Excel NETWORKDAYS.INTL Function is used to return the number of work days between the starting dates and the ending dates, with the inclusion or exclusion of the holidays. NETWORKDAYS.INTL Function: A Brief Intro The Excel NETWORKDAYS.INTL function is used to calculate the number of working days between the starting dates and the ending dates with configurable holiday dates and customizable weekends. NETWORKDAYS.INTL working days Feature

NETWORKDAYS

NETWORKDAYS.INTL



Used For?

Calculates working days between two dates

Calculates working days with custom weekend definitions



What about Weekend Days?

Fixed (Saturday & Sunday only)

Fully customizable (can choose any day(s) as weekend)



Basic Syntax

=NETWORKDAYS(start_date, end_date, [holidays])

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



Holiday Option

Optional list of holidays

Optional list of holidays



Weekend Customization Support?

Not supported

Supported via numbers or a binary string



Can be Used for?

Standard business weeks (Mon–Fri work week)

Non-standard schedules (Sun–Thu work week, rotating shifts)



Functions Introduced in?

Excel 2007

Excel 2010 and later versions. Feature

NETWORKDAYS

NETWORKDAYS.INTL



Used For?

Calculates working days between two dates

Calculates working days with custom weekend definitions



What about Weekend Days?

Fixed (Saturday & Sunday only)

Fully customizable (can choose any day(s) as weekend)



Basic Syntax

=NETWORKDAYS(start_date, end_date, [holidays])

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



Holiday Option

Optional list of holidays

Optional list of holidays



Weekend Customization Support?

Not supported

Supported via numbers or a binary string



Can be Used for?

Standard business weeks (Mon–Fri work week)

Non-standard schedules (Sun–Thu work week, rotating shifts)



Functions Introduced in?

Excel 2007

Excel 2010 and later versions. Feature

NETWORKDAYS

NETWORKDAYS.INTL Feature Feature NETWORKDAYS NETWORKDAYS NETWORKDAYS.INTL NETWORKDAYS.INTL Used For?

Calculates working days between two dates

Calculates working days with custom weekend definitions Used For? Used For? Used For? Calculates working days between two dates Calculates working days between two dates Calculates working days with custom weekend definitions Calculates working days with custom weekend definitions custom weekend What about Weekend Days?

Fixed (Saturday & Sunday only)

Fully customizable (can choose any day(s) as weekend) What about Weekend Days? What about Weekend Days? What about Weekend Days? Fixed (Saturday & Sunday only) Fixed (Saturday & Sunday only) Fully customizable (can choose any day(s) as weekend) Fully customizable (can choose any day(s) as weekend) Basic Syntax

=NETWORKDAYS(start_date, end_date, [holidays])

=NETWORKDAYS.INTL(start_date, end_date, [weekend], [holidays]) Basic Syntax Basic Syntax Basic Syntax =NETWORKDAYS(start_date, end_date, [holidays]) =NETWORKDAYS(start_date, end_date, [holidays]) =NETWORKDAYS.INTL(start_date, end_date, [weekend], [holidays]) =NETWORKDAYS.INTL(start_date, end_date, [weekend], [holidays]) Holiday Option

Optional list of holidays

Optional list of holidays Holiday Option Holiday Option Holiday Option Optional list of holidays Optional list of holidays Optional list of holidays Optional list of holidays Weekend Customization Support?

Not supported

Supported via numbers or a binary string Weekend Customization Support? Weekend Customization Support? Weekend Customization Support? Not supported Not supported Supported via numbers or a binary string Supported via numbers or a binary string Can be Used for?

Standard business weeks (Mon–Fri work week)

Non-standard schedules (Sun–Thu work week, rotating shifts) Can be Used for? Can be Used for? Can be Used for? Standard business weeks (Mon–Fri work week) Standard business weeks (Mon–Fri work week) Non-standard schedules (Sun–Thu work week, rotating shifts) Non-standard schedules (Sun–Thu work week, rotating shifts) Functions Introduced in?

Excel 2007

Excel 2010 and later versions. Functions Introduced in? Functions Introduced in? Functions Introduced in? Excel 2007 Excel 2007 Excel 2010 and later versions. Excel 2010 and later versions. NETWORKDAYS.INTL Function: A Syntax =NETWORKDAYS.INTL(start_date, end_date, [weekend], [holidays]) =NETWORKDAYS.INTL(start_date, end_date, [weekend], [holidays]) start_date: The starting date of the period.
end_date: The ending date of the period.
weekendekend: A string or number representing which days of the week are considered weekends.
holidays: A range of dates to exclude as holidays, and this is an optional one. start_date: The starting date of the period. start_date starting date end_date: The ending date of the period. end_date ending date weekendekend: A string or number representing which days of the week are considered weekends. weekendekend days of the week are considered weekends holidays: A range of dates to exclude as holidays, and this is an optional one. holidays range of dates optional Weekend Codes List supported by NETWORKDAYS.INTL Function: Code

Code



1

Saturday, Sunday (default)



2

Sunday, Monday



3

Monday, Tuesday



4

Tuesday, Wednesday



5

Wednesday, Thursday



6

Thursday, Friday



7

Friday, Saturday Code

Code



1

Saturday, Sunday (default)



2

Sunday, Monday



3

Monday, Tuesday



4

Tuesday, Wednesday



5

Wednesday, Thursday



6

Thursday, Friday



7

Friday, Saturday Code

Code Code Code Code Code 1

Saturday, Sunday (default) 1 1 Saturday, Sunday (default) Saturday, Sunday (default) 2

Sunday, Monday 2 2 Sunday, Monday Sunday, Monday 3

Monday, Tuesday 3 3 Monday, Tuesday Monday, Tuesday 4

Tuesday, Wednesday 4 4 Tuesday, Wednesday Tuesday, Wednesday 5

Wednesday, Thursday 5 5 Wednesday, Thursday Wednesday, Thursday 6

Thursday, Friday 6 6 Thursday, Friday Thursday, Friday 7

Friday, Saturday 7 7 Friday, Saturday Friday, Saturday Binary Code

Meaning



0000011

Saturday & Sunday are weekends



1111111

All days are weekends (0 workdays)



0000000

No weekends (every day is a workday)



1000001

Monday & Sunday are weekends



0101010

Tuesday, Thursday, and Saturday are weekends Binary Code

Meaning



0000011

Saturday & Sunday are weekends



1111111

All days are weekends (0 workdays)



0000000

No weekends (every day is a workday)



1000001

Monday & Sunday are weekends



0101010

Tuesday, Thursday, and Saturday are weekends Binary Code

Meaning Binary Code Binary Code Meaning Meaning 0000011

Saturday & Sunday are weekends 0000011 0000011 Saturday & Sunday are weekends Saturday & Sunday are weekends 1111111

All days are weekends (0 workdays) 1111111 1111111 All days are weekends (0 workdays) All days are weekends (0 workdays) 0000000

No weekends (every day is a workday) 0000000 0000000 No weekends (every day is a workday) No weekends (every day is a workday) 1000001

Monday & Sunday are weekends 1000001 1000001 Monday & Sunday are weekends Monday & Sunday are weekends 0101010

Tuesday, Thursday, and Saturday are weekends 0101010 0101010 Tuesday, Thursday, and Saturday are weekends Tuesday, Thursday, and Saturday are weekends Basic Examples of Using NETWORKDAYS.INTL Function: In the following example, I have explained how to use the NETWORKDAYS.INTL function to calculate working days with three different scenarios: No weekends, Saturday and Sunday as weekends, and only Sunday as a weekend. I have also used both code formats (Binary and Numerical) to identify holidays. Please take a look. NETWORKDAYS.INTL three different scenarios No weekends Saturday and Sunday as weekends only Sunday as a weekend both code formats Binary and Numerical The Example seems to be simple, but it is effective for quick understanding. Explanation of the above Example: In this example, the formula =NETWORKDAYS.INTL(B3, C3, “0000011”, L$3:L$4) calculates the number of working days between January 2, 2024, and January 31, 2024, while excluding weekends and holidays.
The code “0000011” tells Excel that Saturday and Sunday are considered weekends. The holiday list in cells L3:L4 includes January 1, but since it falls outside the date range, only weekends are excluded.
Since January 2024 has 8 weekend days, Excel subtracts these from the total 31 days of the month, resulting in 22 working days. In this example, the formula =NETWORKDAYS.INTL(B3, C3, “0000011”, L$3:L$4) calculates the number of working days between January 2, 2024, and January 31, 2024, while excluding weekends and holidays. =NETWORKDAYS.INTL(B3, C3, “0000011”, L$3:L$4) working days January 2, 2024, January 31, 2024 weekends and holidays The code “0000011” tells Excel that Saturday and Sunday are considered weekends. The holiday list in cells L3:L4 includes January 1, but since it falls outside the date range, only weekends are excluded. “0000011” Saturday and Sunday cells L3:L4 January 1 Since January 2024 has 8 weekend days, Excel subtracts these from the total 31 days of the month, resulting in 22 working days. January 2024 8 weekend days 31 days 22 working days How the NETWORKDAYS.INTL Calculates the Working Days Is There any Manual Formula Available to Replicate the NETWORKDAYS.INTL Functionality? Yes, there is a manual formula available; you may need to use other Excel functions combined to get the results. Scenarios That’s it. This article was originally published on How to Use Excel NETWORKDAYS.INTL Function? How to Use Excel NETWORKDAYS.INTL Function?

Walkthroughs, tutorials, guides, and tips. This story will teach you how to do something new or how to do something better.

How WEEKNUM Simplifies Date Management in Excel

The Best Way to Use the Excel NETWORKDAYS.INTL Function

About Author

Comments

TOPICS

THIS ARTICLE WAS FEATURED IN

Related Stories

Untitled Story

Using the Excel DAYS360 Function for Financial Analysis- A Guide

4 Data Transformations Made Spreadsheet-Easy

5 Excel Features That Can Grow Your Net Worth in No Time

5 Ways to Add Security to Excel & PDF with .NET Document APIs

7 Essential Things in Excel That You Definitely Need to Master

Using the Excel DAYS360 Function for Financial Analysis- A Guide

4 Data Transformations Made Spreadsheet-Easy

5 Excel Features That Can Grow Your Net Worth in No Time

5 Ways to Add Security to Excel & PDF with .NET Document APIs

7 Essential Things in Excel That You Definitely Need to Master

Light-Mode

Classic

Newspaper

Dark-Mode

Neon Noir

Minty

HN StartUps