Written and reviewed by FormulaCraft Team. Each formula on this page is run through our verification engine before publishing.
Last reviewed:
DAYS
DAYS subtracts the start date from the end date and returns the number of calendar days between them. Unlike DATEDIF it accepts arguments in end-date, start-date order, making it convenient for straightforward day-difference calculations such as project duration or age in days.
Excel
=DAYS(DATE(2024,12,31),DATE(2024,1,1))Google Sheets
=DAYS(DATE(2024,12,31),DATE(2024,1,1))✓
Verified example
Computed by a real spreadsheet engine on the sample data below.
| StartDate | EndDate | DayCount |
| 2024-01-01 | 2024-03-31 | |
| 2024-04-01 | 2024-06-30 | |
| 2024-07-15 | 2024-12-15 | |
| 2023-12-01 | 2024-01-15 |
=DAYS(DATE(2024,12,31),DATE(2024,1,1))→365
Try it with your data
Edit the grid or formula, then run it through a real spreadsheet engine — no signup.
Sample data — click any cell to edit
Runs server-side · free · no signup
How it works
- 1Place the earlier (start) date in A2 and the later (end) date in B2.
- 2In C2 type =DAYS(B2,A2) — note the order is end_date first, start_date second.
- 3The result is a plain integer representing total calendar days including the start day.
Need a version for your data?
Try: “How many days are there between each project start date and its deadline?”