Returns the number of days between two dates


DAYS(enddate, startdate)
startdate and enddate may be dates as numbers or text (which is converted to number form). DAYS returns enddate - startdate. The result may be negative.


DAYS("2008-03-03", "2008-03-01")
returns 2, the number of days between 1March08 and 3March08.
DAYS(A1, A2)
where cell A1 contains the date 2008-06-09 and A2 contains 2008-06-02 returns 7.

Created with Zapof