Excel Function

NETWORKDAYS.INTL

Returns working days with customizable weekends.

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

Arguments

start_date

Required

Enter a date/reference-related value.

end_date

Required

Enter a date/reference-related value.

weekend

Optional

Set weekend pattern with codes 1-7 / 11-17, or a 7-character string such as "0000011".

holidays

Optional

Specify a reference range. You can drag or click start/end cells.

Practice Preview

Use NETWORKDAYS.INTL to calculate business days from cell B2 (Start Date in column B) to cell C2 (End Date in column C) using 1 (Saturday and Sunday) and Holiday in column E. You can set ranges by dragging from the start cell to the end cell in the same argument field.

Example Table

#
ATask ID
BStart Date
CEnd Date
DNotes
EHoliday
2T0012026/03/012026/03/05Standard task2026/03/03
3T0022026/03/032026/03/10Priority task2026/03/06
4T0032026/03/052026/03/12Standard task2026/03/10
5T0042026/03/082026/03/14Urgent task2026/03/12
6
7
8

How to Use (Formula)

=NETWORKDAYS.INTL(B2, C2, 1, E2:E5)

Result

3

Practice This Function

Start Function PracticeBack to Function List

NETWORKDAYS.INTL FAQ

How do I use NETWORKDAYS.INTL in Excel?

Use NETWORKDAYS.INTL when you want to count working days with custom weekend rules. Enter Start date, End date, Weekend pattern in that order, then add optional arguments when needed.

Where can I practice NETWORKDAYS.INTL?

Use the "Start Function Practice" button to jump straight into NETWORKDAYS.INTL drills.

What arguments does NETWORKDAYS.INTL use?

The main arguments are Start date, End date, Weekend pattern, Holiday range. Start with the required ones, then add optional arguments if needed.