Which MS Excel function calculates the number of days between two dates?
GAP
DATES
DAYS
DAYS 300
Correct answer: DAYS
Solution
The DAYS function in Excel calculates the number of days between two dates. Syntax: =DAYS(end_date, start_date). GAP, DATES, and DAYS300 are not valid Excel functions.