DAYS function

DAYS calculates the difference between two date values. The result is an integer and returns the number of days between the two days.



  • date_1 is the start date.
  • date_2 is the end date.

If date_1 is an earlier date than date_2, the result is a negative number.


=DAYS("1/1/2010",NOW()) returns the number of days from 1 January 2010 until today.

=DAYS("10/10/1990","10/10/2000") returns -3653.

=DAYS("1/1/2015",NOW()) returns 430.