This function calculates the number of days between two dates.
DAYS(end_date, start_date)
Specify the end_date and start_date argument as a number (as in 37806), a string or reference to cells containg the information.
Accepts numeric or string data for both arguments. Returns numeric data.
DAYS("5/15/11","4/1/11") gives the result 44.