[Date Prev] | [Thread Prev] | [Thread Next] | [Date Next] -- [Date Index] | [Thread Index] | [List Home]
Subject: An error in definition of DAYS spreadsheet function
Hi! https://docs.oasis-open.org/office/v1.2/os/OpenDocument-v1.2-os-part2.html#DAYS
Semantics: Returns the number of days between two dates. If StartDate and EndDate are Numbers, this is EndDate â StartDate. If they are both Text, this is DATEVALUE(StartDate) â DATEVALUE(EndDate).
The order of arguments in the "If they are both Text" part is reversed, it must be "DATEVALUE(EndDate) â DATEVALUE(StartDate)".
-- Best regards, Mike Kaganski
[Date Prev] | [Thread Prev] | [Thread Next] | [Date Next] -- [Date Index] | [Thread Index] | [List Home]