DAYS Function Explained

The DAYS() function in Microsoft Excel calculates the number of days between two dates. It takes two arguments: the start date and the end date. It returns the number of days between the two dates, including the start and end dates.

DAYS Function Syntax

DAYS(end_date, start_date)

  • end_date: The end date of the period. A number that represents a date, a string that can be recognized as a date, or a reference to a cell containing a date.
  • start_date: The start date of the period. A number that represents a date, a string that can be recognized as a date, or a reference to a cell containing a date.