All functions / Date & Time
DAYS
The number of days between two dates.
Syntax
=DAYS(end_date, start_date)
Arguments
end_date: The later date.start_date: The earlier date.
Example
=DAYS("2025-12-25", TODAY()) → Days until 25 December
All functions / Date & Time
The number of days between two dates.
=DAYS(end_date, start_date)
end_date: The later date.start_date: The earlier date.=DAYS("2025-12-25", TODAY()) → Days until 25 December