Skip to main content

DAYS

Returns the number of days between two dates.

Syntax​

DAYS(end_date, start_date)

Arguments​

  • end_date: The ending date.
  • start_date: The starting date.

Example​

DAYS("2025-03-10", "2025-03-01") → Returns 9
DAYS(A1, B1) → Returns the number of days between the dates in cells A1 and B1