DAYS
Returns the number of days between two dates.
Date & TimeDates & Time Calculations
What it does
Calculates the number of days between an end date and start date.
Syntax
DAYS(end_date, start_date)
Arguments
end_date(date) — The end date.start_date(date) — The start date.
Examples
Days Between
Calculate days between dates.
FORMULA
=DAYS(B2, A2)
RESULT
365
SAMPLE DATA
| A | B | |
|---|---|---|
| 1 | Start | End |
| 2 | 2023-01-01 | 2024-01-01 |