# EDATE, EOMONTH & NETWORKDAYS (Excel lesson 24 of 45)

> Add months, find month-ends and count business days.

Source: https://spreadsheetpractice.com/learn/edate-eomonth-networkdays · Updated October 29, 2026

- **Course:** [Excel course](https://spreadsheetpractice.com/learn), track "Dates"
- **Time:** about 9 minutes, 3 graded exercises
- **Functions:** `EDATE`, `EOMONTH`, `NETWORKDAYS`
- **Access:** Pro (the lesson text is free; the graded exercises need Pro)
- **Key formula:** `=EDATE(B2,C2)`: Start + N months

## How it works

Add days with plain `+`. Add months with `EDATE(start, months)`, which handles short months: one month after January 31 is February 28.

`EOMONTH(start, 0)` is the last day of that month; use 1 for next month. `NETWORKDAYS(start, end)` counts Monday to Friday, inclusive, and takes an optional holiday list. For ages and tenure, `DATEDIF(start, end, "Y")` gives whole years.

## Syntax

| Formula | What it does |
|---|---|
| `=EDATE(B2,C2)` | Start + N months |
| `=EOMONTH(B2,0)` | Month-end |
| `=NETWORKDAYS(B2,D2)` | Business days, inclusive |
| `=DATEDIF(B2,TODAY(),"Y")` | Whole years elapsed |

## Watch out for

- A result like 46219 means the cell isn't formatted as a date yet.
- NETWORKDAYS counts both the start and end day.

## The exercises

Solve them in the live grid at [EDATE, EOMONTH & NETWORKDAYS](https://spreadsheetpractice.com/learn/edate-eomonth-networkdays). Each answer is graded, then re-checked on changed data so typed-in numbers don't pass.

1. **Contract end dates.** In D2, calculate each contract's end date: the start date plus the term in months. Fill down to D6.
2. **Bill at month-end.** In E2, return the last day of each contract's start month. Fill down to E6.
3. **Business days.** In F2, count the weekdays from each start date to its end date. Fill down to F6.

Previous: [DATE, YEAR, MONTH & TEXT](https://spreadsheetpractice.com/learn/date-year-month-text) · Next: [Tenure, quarters & weekdays](https://spreadsheetpractice.com/learn/tenure-quarters-weekdays)

---

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