The Excel DAYS function returns the number of days between two supplied dates. This function was only introduced in Excel 2013 and so is not available in earlier versions of Excel.
Syntax: DAYS( start_date, end_date )
Note that the supplied start_date and end_date arguments should be input as either references to cells containing dates or dates returned from formulas. If you attempt to input the start_date and end_date as text, there is a chance that Excel may misinterpret this due to different date systems, or date interpretation settings.
DAYS Function Example
The following spreadsheet shows a simple example of the Excel DAYS function.
DAYS Function Errors
#NUM! – Occurs if one or both of the supplied start_date and end_date arguments are numeric values, but are not recognised as valid dates.
#VALUE! – Occurs if one or both of the supplied start_date and end_date arguments are text values that can not be interpreted as dates.