The DAYS function returns the number of days between two supplied dates.
- This function was introduced in Excel 2013 and so is not available in earlier versions.
|start_date||The start date|
|end_date||The end date|
The start_date and end_date arguments for the DAYS function should be input as either:
- A reference to a cell containing a date or,
- A date returned from another function or formula
Warning: Although you can input date arguments as date serial numbers, this is not recommended as date serial numbering does vary across different computer systems.
|1||Start date||End date||Formula||Result|
|2||Thu 01-Jan-2015||Mon 02-Feb-2015||=DAYS(B2,A2)||32|
Common Function Error(s)
|Problem||What went wrong|
|#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|
|#NUM!||Occurs if one or both of the supplied start_date and end_date arguments are numeric values, but are not recognized as valid dates|