Excel DAYS Function

Excel DAYS Function

Sponsored Link


Get days between dates

Return value 

A number representing days.


=DAYS (end_date, start_date)


  • end_date – The end date.
  • start_date – The start date.

Usage notes 

The DAYS function returns the number of days between two dates. With a start date in A1 and end date in A2,


Will return the same result as:


Unlike the simple formula above, the DAYS function can also handle dates in text format, as long as the date is recognized by Excel. For example:

=DAYS("7/15/2016","7/1/2016") // returns 14

The DAYS function does not take into account any time value that’s part of the date.

Sponsored Link

1 votes. 4 / 5

Excel - Excel Functions - Excel Formulas