DAYS
Date & timeExcel 2013The number of days between two dates.
Syntax
DAYS(end_date, start_date)
Examples
=DAYS(B2, A2)
→
Good to know
- B2 - A2 does the same thing and works everywhere.
Related functions
More Date & time functions
Syntax follows Microsoft’s documentation. Examples are written to be pasted into a cell and checked. Argument separators may be ; in your locale. The AI explainer runs on a free community model — verify anything important.