Excel + Google Sheets · DAYS
Days between two dates
Returns the number of days between two dates. End date first.
The formula
=DAYS(B2, A2)What each part means
B2End dateA2Start date
Example
| A | B | C | |
|---|---|---|---|
| 1 | Start | End | Days |
| 2 | 2026-11-02 | 2026-12-01 | |
| 3 | 2026-11-10 | 2026-11-30 | |
| 4 | 2027-01-01 | 2027-03-01 |
| A | B | C | |
|---|---|---|---|
| 1 | Start | End | Days |
| 2 | 2026-11-02 | 2026-12-01 | 29 |
| 3 | 2026-11-10 | 2026-11-30 | 20 |
| 4 | 2027-01-01 | 2027-03-01 | 59 |
Step by step
- Click cell C2.
- Type the formula:
=DAYS(B2, A2) - Press Enter.
- Drag the small square in the bottom-right corner of the cell down to copy it to the other rows.
Where it works
- Every version of Excel
- Google Sheets
- Excel for the web (free)