DAYS Function
Counts the days between two dates.
Category
Date & Time
Available in
Excel 2013+, Microsoft 365
Returns
A whole number of days
Want to practice DAYS in a real spreadsheet? Open a blank sheet in our Practice Sandbox and try it with live data, with the AI Excel tutor beside you. No Excel needed — just a free account.Try it free in the Sandbox
Overview
DAYS returns the number of days from a start date to an end date. Notice the order: the end date comes first.
It's the same as subtracting one date from the other, but it also accepts dates written as text.
Syntax
=DAYS(end_date, start_date) Explain
Arguments
| Argument | Required? | What it does |
|---|---|---|
| end_date | Yes | The later date. |
| start_date | Yes | The earlier date. If it's after end_date, the result is negative. |
Examples
Example 1 — Length of each project
Count the calendar days from start to finish.
C2fx=DAYS(B2,A2)
| A | B | C | |
|---|---|---|---|
| 1 | Start | Finish | Days |
| 2 | 3/2/2026 | 3/31/2026 | 29 |
| 3 | 1/15/2026 | 4/15/2026 | 90 |
| 4 | 12/20/2025 | 1/5/2026 | 16 |
=DAYS(B2,A2) Explain
Example 2 — Including both the start and the end day
Add 1 when both days count, such as a hotel stay counted in days.
=DAYS(B2,A2)+1 Explain
Common mistakes
- A negative answer. The arguments are the wrong way round — end date first, then start date.
Notes
- For working days only, use NETWORKDAYS. For complete months or years, use DATEDIF.
- Related functions: DAYS360, DATEDIF, NETWORKDAYS.

Author
Kyle Stott
Certified Microsoft Excel Expert
Kyle has worked professionally with Microsoft Excel for over a decade and has consulted on and taught Excel best practices to over 400 companies across 30+ countries.