Skip to Content

DAYS

Returns the number of days between two dates

Syntax

DAYS(end_date, start_date)

Parameters

  • end_date: Required. The end or later date
  • start_date: Required. The start or earlier date

Example

=DAYS("3/15/2024", "1/1/2024")
Returns: NumberSince: Excel 2013