Excel Function

NETWORKDAYS

Returns number of working days between dates.

NETWORKDAYS(start_date, end_date, [holidays])

Arguments

start_date

Required

Enter a date/reference-related value.

end_date

Required

Enter a date/reference-related value.

holidays

Optional

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

Practice Preview

Use NETWORKDAYS to calculate business days from cell B2 (Start Date in column B) to cell C2 (End Date in column C) using Holiday in column E as holidays. 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
2	T001	2026/03/01	2026/03/05	Standard task	2026/03/03
3	T002	2026/03/03	2026/03/10	Priority task	2026/03/06
4	T003	2026/03/05	2026/03/12	Standard task	2026/03/10
5	T004	2026/03/08	2026/03/14	Urgent task	2026/03/12
6
7
8

How to Use (Formula)

=NETWORKDAYS(B2, C2, E2:E5)

Result

Practice This Function

Start Function Practice Back to Function List

NETWORKDAYS FAQ

How do I use NETWORKDAYS in Excel?

Use NETWORKDAYS when you want to count working days. Enter Start date, End date, Holiday range in that order, then add optional arguments when needed.

Where can I practice NETWORKDAYS?

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

What arguments does NETWORKDAYS use?

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