The Excel DAYS function (new in Excel 2013) returns the number of whole days between two date serial numbers. It ignores time portions of date-time serial numbers.
Excel DAYS Function Syntax
| Syntax: | =DAYS( end_date, start_date) |
| start_date | A date in a format Excel recognises known as the date-time serial number, or text |
| end_date | A date in a format Excel recognises known as the date-time serial number, or text |
Excel DAYS Function Examples
Notice the first day isn't included in the count. You need to add 1 to the result if you want inclusive dates.
Tip: The Excel DAYS function works with dates stored as text (cell B13), but this is not reliable. It's always best to work with date serial numbers.
Free eBook - Working with Date & Time in Excel
Everything you need to know about Date and Time in Excel, including all Date functions explained with examples - Download the free eBook and Excel file with detailed instructions.
Enter your email address below to download the sample workbook.
Download the Excel Workbook and PDF. Note: This is a zip file including an Excel workbook with detailed instructions and a PDF version for your reference.
Related Tutorials
| Excel NETWORKDAYS Function | Returns the number of whole networkdays (excluding weekends & holidays), between two dates |
| Excel NETWORKDAYS.INTL Function | Returns the number of whole networkdays (excluding weekends & holidays), between two dates, using parameters to specify weekend days |
| Excel DAYS360 Function | Calculates the number of days between 2 dates, based on a 360-day year (12 x 30-day months) |
| Excel DATEDIF Function | Calculates the number of days, months, or years between two dates. This function is useful in formulas where you need to calculate an age. |
| Excel YEARFRAC Function | Calculates the fraction of the year represented by the number of whole days between two dates |