|
<< Click to Display Table of Contents >> DAYS (days between two dates) |
Syntax:
DAYS(EndDate, StartDate)
Description:
Returns the number of days between two dates.
Please note the order of the parameters: The end date has to be specified first, the start date second.
Note:
This function was revised in PlanMaker 2016: The order of its two parameters was swapped.
Background info: The DAYS function has been available in PlanMaker for a long time. Excel did not have this function until Excel 2013. In Excel 2013, a function with the same name was added. It returns exactly the same results – however, the order of its parameters is different: first the end date, then the start date. In order to be compatible with Excel, the parameter order was swapped in PlanMaker 2016.
The previous version of the function was renamed to DAYSP. Thus, the functions DAYS and DAYSP are identical, only the order of their parameters differs:
DAYS(EndDate, StartDate) equals
DAYSP(StartDate, EndDate)
Compatibility notes:
Microsoft Excel supports this function only in version 2013 or later. In older versions, the function is unknown.
Example:
DAYS("01/14/2018", "01/01/2018") returns 13
If cell A1 contains the date value 01/14/2018 and cell A2 contains the date value 01/01/2018:
DAYS(A1, A2) returns 13
See also: