DAYS
Counts the days between two dates.
How it’s written
DAYS(end, start)Example
| A | B | |
|---|---|---|
| 1 | Start | End |
| 2 | 46,096 | 46,126 |
=DAYS(B2,A2)Result: 30
The dates are 30 days apart.
Try it yourself
Open a live sheet with this example, and type the formula yourself. It takes a moment to load.
Worth knowing
End comes first. Simply subtracting the dates also works.
Practice it properly
Calculating with dates gives you real tasks, with your formulas tested on data you haven’t seen.