Excel practice › Excel functions › NETWORKDAYS
NETWORKDAYS in Excel: working days between two dates
NETWORKDAYS counts the working days between two dates: every Monday to Friday in the period, with the start date and the end date both included. For a task that runs from Monday 5/4/2026 to Friday 5/8/2026, =NETWORKDAYS(B2,C2) returns 5.
Weekends are always left out. Holidays are left out only if you list their dates in a range and pass it as the third argument.
Syntax
=NETWORKDAYS(start_date, end_date, [holidays])
start_date- The first day of the period. It is counted, if it's a working day.
end_date- The last day of the period. It is counted too.
holidays- Optional: a range of dates to leave out of the count, like the days the company is closed. Without it, only Saturdays and Sundays are skipped.
| A | B | C | D | E | F | G | |
|---|---|---|---|---|---|---|---|
| 1 | Task | Start | End | Work days | Holiday | Date | |
| 2 | Site survey | 5/4/2026 | 5/8/2026 | 5 | Memorial Day | 5/25/2026 | |
| 3 | Permits | 5/11/2026 | 5/29/2026 | Juneteenth | 6/19/2026 | ||
| 4 | Framing | 6/1/2026 | 7/10/2026 | July 4 (observed) | 7/3/2026 | ||
| 5 | Electrical | 7/13/2026 | 7/24/2026 | Labor Day | 9/7/2026 | ||
| 6 | Inspection | 8/31/2026 | 9/11/2026 |
=C2-B2, gives 4, the number of days after the start.How Excel counts
- It goes through every day from start_date to end_date, the two ends included.
- It skips every Saturday and Sunday.
- If you gave it a holidays range, it also skips every date found there.
- It returns how many days are left.
So a task that starts and ends on the same weekday counts 1, not 0: =NETWORKDAYS(B2,B2) is 1. If you want the days after the start, subtract 1 from the result.
The three ways it goes wrong
Each of these is live below. Fix the formula in the box and watch the cell.
1. Subtracting the dates. A subtraction counts calendar days, weekends included:
| A | B | C | D | E | F | G | |
|---|---|---|---|---|---|---|---|
| 1 | Task | Start | End | Work days | Holiday | Date | |
| 2 | Site survey | 5/4/2026 | 5/8/2026 | Memorial Day | 5/25/2026 | ||
| 3 | Permits | 5/11/2026 | 5/29/2026 | 18 | Juneteenth | 6/19/2026 | |
| 4 | Framing | 6/1/2026 | 7/10/2026 | July 4 (observed) | 7/3/2026 | ||
| 5 | Electrical | 7/13/2026 | 7/24/2026 | Labor Day | 9/7/2026 | ||
| 6 | Inspection | 8/31/2026 | 9/11/2026 |
=NETWORKDAYS(B3,C3): 15 working days.2. Forgetting the holidays. NETWORKDAYS knows nothing about holidays. A Monday is a working day to it, also when it's Memorial Day:
| A | B | C | D | E | F | G | |
|---|---|---|---|---|---|---|---|
| 1 | Task | Start | End | Work days | Holiday | Date | |
| 2 | Site survey | 5/4/2026 | 5/8/2026 | Memorial Day | 5/25/2026 | ||
| 3 | Permits | 5/11/2026 | 5/29/2026 | 15 | Juneteenth | 6/19/2026 | |
| 4 | Framing | 6/1/2026 | 7/10/2026 | July 4 (observed) | 7/3/2026 | ||
| 5 | Electrical | 7/13/2026 | 7/24/2026 | Labor Day | 9/7/2026 | ||
| 6 | Inspection | 8/31/2026 | 9/11/2026 |
=NETWORKDAYS(B3,C3,G2:G5) gives 14.3. A holidays range with something else in it. The range must hold dates and nothing else. Include the names next to them, or the header, and the result is an error:
| A | B | C | D | E | F | G | |
|---|---|---|---|---|---|---|---|
| 1 | Task | Start | End | Work days | Holiday | Date | |
| 2 | Site survey | 5/4/2026 | 5/8/2026 | Memorial Day | 5/25/2026 | ||
| 3 | Permits | 5/11/2026 | 5/29/2026 | #VALUE! | Juneteenth | 6/19/2026 | |
| 4 | Framing | 6/1/2026 | 7/10/2026 | July 4 (observed) | 7/3/2026 | ||
| 5 | Electrical | 7/13/2026 | 7/24/2026 | Labor Day | 9/7/2026 | ||
| 6 | Inspection | 8/31/2026 | 9/11/2026 |
=NETWORKDAYS(B3,C3,G2:G5).Two more things about the holidays range. A holiday that falls on a Saturday or Sunday changes nothing, since that day wasn't counted anyway: July 4, 2026 is a Saturday, which is why this list has the Friday the company closes instead. And when you copy the formula down a column, lock the range with dollar signs, $G$2:$G$5, so it doesn't slide down with each row.
Practice: 3 exercises
Type the formula in the box, press Enter. Clicking a cell inserts its address. Each answer is checked on the data you see and again on changed data, so a typed-in value won't pass.
In D5, count the working days of the Electrical task, from its start in B5 to its end in C5. No holiday falls inside it.
| A | B | C | D | E | F | G | |
|---|---|---|---|---|---|---|---|
| 1 | Task | Start | End | Work days | Holiday | Date | |
| 2 | Site survey | 5/4/2026 | 5/8/2026 | Memorial Day | 5/25/2026 | ||
| 3 | Permits | 5/11/2026 | 5/29/2026 | Juneteenth | 6/19/2026 | ||
| 4 | Framing | 6/1/2026 | 7/10/2026 | July 4 (observed) | 7/3/2026 | ||
| 5 | Electrical | 7/13/2026 | 7/24/2026 | Labor Day | 9/7/2026 | ||
| 6 | Inspection | 8/31/2026 | 9/11/2026 |
Show the answer
=NETWORKDAYS(B5,C5) gives 10.
Monday 7/13 to Friday 7/24 is two full working weeks: 10 days. A subtraction would say 11, the calendar days after the start.
The Framing task runs from 6/1/2026 to 7/10/2026, and the company is closed on some of those days. In D4, count its working days, leaving out the holidays listed in G2:G5.
| A | B | C | D | E | F | G | |
|---|---|---|---|---|---|---|---|
| 1 | Task | Start | End | Work days | Holiday | Date | |
| 2 | Site survey | 5/4/2026 | 5/8/2026 | Memorial Day | 5/25/2026 | ||
| 3 | Permits | 5/11/2026 | 5/29/2026 | Juneteenth | 6/19/2026 | ||
| 4 | Framing | 6/1/2026 | 7/10/2026 | July 4 (observed) | 7/3/2026 | ||
| 5 | Electrical | 7/13/2026 | 7/24/2026 | Labor Day | 9/7/2026 | ||
| 6 | Inspection | 8/31/2026 | 9/11/2026 |
Show the answer
=NETWORKDAYS(B4,C4,G2:G5) gives 28.
There are 30 weekdays from June 1 to July 10. Two holidays fall on weekdays inside the period, June 19 and July 3, which leaves 28. Memorial Day and Labor Day are in the list too, but outside these dates, so they change nothing.
Each task has a budget of working days in column D. In E3, show Over if the Permits task takes more working days than its budget, and OK otherwise. The holidays in G2:G5 are not working days.
| A | B | C | D | E | F | G | |
|---|---|---|---|---|---|---|---|
| 1 | Task | Start | End | Budget days | Status | Holidays | |
| 2 | Site survey | 5/4/2026 | 5/8/2026 | 5 | 5/25/2026 | ||
| 3 | Permits | 5/11/2026 | 5/29/2026 | 12 | 6/19/2026 | ||
| 4 | Framing | 6/1/2026 | 7/10/2026 | 30 | 7/3/2026 | ||
| 5 | Electrical | 7/13/2026 | 7/24/2026 | 10 | 9/7/2026 | ||
| 6 | Inspection | 8/31/2026 | 9/11/2026 | 9 |
Show the answer
=IF(NETWORKDAYS(B3,C3,G2:G5)>D3,"Over","OK") gives Over.
NETWORKDAYS returns 14 for this task: 15 weekdays minus Memorial Day. 14 is more than the budget of 12, so IF returns Over. NETWORKDAYS gives a number like any other, so it can sit inside IF or a calculation.
Questions people ask
Does NETWORKDAYS include the start date and the end date?
Yes, both, when they are working days. Monday to Friday of the same week is 5, and a single weekday counted from itself to itself is 1. For the working days that have passed since the start, subtract 1.
How do I exclude holidays from NETWORKDAYS?
List the holiday dates in a column and pass that range as the third argument: =NETWORKDAYS(B2,C2,$G$2:$G$5). The range must hold only dates. The dollar signs keep it in place when the formula is copied down.
What if the weekend isn't Saturday and Sunday?
Use NETWORKDAYS.INTL, which has an extra argument to say which days of the week are the weekend. NETWORKDAYS itself always skips Saturday and Sunday. The sheets on this page don't run NETWORKDAYS.INTL.
How do I find the date a number of working days after a start date?
That's the reverse question, and it has its own function: =WORKDAY(start_date, days, [holidays]) returns the date that many working days after the start, skipping weekends and the holidays you list.