# NETWORKDAYS function in Excel

> NETWORKDAYS counts the working days between two dates, Monday to Friday, including both the start and end date.

Source: https://spreadsheetpractice.com/functions/networkdays · Updated October 28, 2026 · Formulas and results on this page were run by the Spreadsheet Practice formula engine on November 20, 2026

## Quick answer

- **What it does:** NETWORKDAYS counts the working days between two dates, Monday to Friday, including both the start and end date.
- **Syntax:** `=NETWORKDAYS(start_date, end_date, [holidays])`
- **Most common use:** `=NETWORKDAYS(B2,C2)` returns 21 (21 weekdays in the audit window)
- **Available in:** Every current version
- **Category:** [Date functions](https://spreadsheetpractice.com/functions/category/date)
- **Returns:** A whole number of working days.
- **Google Sheets:** Works the same in Google Sheets.

## What it does

NETWORKDAYS counts the working days between two dates, Monday to Friday, including both the start and end date. Add a range of holiday dates and it skips those too. Use it for project timelines, SLA tracking and payroll periods.

## Syntax

`=NETWORKDAYS(start_date, end_date, [holidays])`

| Argument | Required? | What it is |
|---|---|---|
| `start_date` | Required | The first day of the period. |
| `end_date` | Required | The last day of the period. Both days count if they are weekdays. |
| `holidays` | Optional | An optional range of dates to exclude, such as public holidays. |

## Examples

Each result was calculated by running the formula on the sample sheet.

| Cell | Formula | Result | What it shows |
|---|---|---|---|
| G2 | `=NETWORKDAYS(B2,C2)` | 21 | 21 weekdays in the audit window |
| G3 | `=NETWORKDAYS(B2,C2,E2:E4)` | 19 | 19 once Thanksgiving and the day after are removed |
| G4 | `=NETWORKDAYS(B3,C3,E2:E4)` | 22 | December has 22 working days after Christmas Day |

### The sample sheet

Every formula above runs on this data:

|  | A | B | C | D | E | F | G |
|---|---|---|---|---|---|---|---|
| 1 | Project | Start | End |  | Holidays |  | Result |
| 2 | Site audit | 11/2/2026 | 11/30/2026 |  | 11/26/2026 |  | 21 |
| 3 | Migration | 12/1/2026 | 12/31/2026 |  | 11/27/2026 |  | 19 |
| 4 |  |  |  |  | 12/25/2026 |  | 22 |

## Common mistakes

| What you see | Why, and how to fix it |
|---|---|
| One day more than expected | NETWORKDAYS counts both the start and the end date. Subtract 1 if the start day shouldn't count. |
| Holidays aren't skipped | The holiday cells hold text, not dates, or the range moved when you filled down. Use real dates and lock the range: $E$2:$E$4. |
| Your weekend isn't Saturday and Sunday | NETWORKDAYS assumes a Saturday–Sunday weekend. NETWORKDAYS.INTL lets you choose different weekend days. |

## Tips

- Keep holidays in one named range or table column and reference it everywhere, so updating the list fixes every formula.

## Related functions

- [WORKDAY](https://spreadsheetpractice.com/functions/workday): WORKDAY returns the date a given number of working days before or after a start date, skipping weekends and any holidays you list.
- [DAYS](https://spreadsheetpractice.com/functions/days): DAYS returns the number of days between two dates.
- [WEEKDAY](https://spreadsheetpractice.com/functions/weekday): WEEKDAY returns the day of the week for a date as a number.

## Questions

### How do I count business days between two dates in Excel?

Use =NETWORKDAYS(start_date,end_date). Add a holiday range as the third argument to exclude public holidays.

### Does NETWORKDAYS include the start date?

Yes. Both the start and end date are counted when they fall on weekdays.

### How is NETWORKDAYS different from WORKDAY?

NETWORKDAYS counts the working days between two dates. WORKDAY goes the other way: it returns the date a number of working days away.

## Practice

A graded NETWORKDAYS exercise ("Business days") is on [the NETWORKDAYS page](https://spreadsheetpractice.com/functions/networkdays). It is checked instantly, then re-checked on changed data.

Lessons that use NETWORKDAYS:

- [Lesson 24: EDATE, EOMONTH & NETWORKDAYS](https://spreadsheetpractice.com/learn/edate-eomonth-networkdays) (Pro)

---

Spreadsheet Practice (https://spreadsheetpractice.com) teaches spreadsheet formulas by practice: every exercise is graded in a live grid and re-checked on changed data.
