Question: how to get excel to calculate number of days between two dates?
Answer: The DAYS Function =DAYS() The DAYS function returns the number of days between two dates in a spreadsheet. The function only requires two arguments (end date, start date). It is important to select the end date followed by the start date otherwise your results will display a negative number of days.