Talk:Documentation/Calc Functions/DAYS

(1) Summary. Do these two sentences say anything different or is the second repetition of the first? Suggest the following (simpler) replacement paragraph – “Calculates the number of days between two dates.”.
(2) Summary. Suggest including the following as a tip – “To keep dates from being interpreted as parts of formulas use the DATE function, for example, DATE(1954;7;20), or place the date in quotation marks and use the ISO 8601 notation, for example, "1954-07-20". Avoid using locale dependent date formats such as "07/20/54", the calculation may produce errors if the document is loaded under different locale settings.”.
(3) Returns. Suggest the following re-word – “Returns a real number which is the difference between the two given dates in days.”
(4) Arguments, Date1. Suggest the following replacement text – “Date1 is a date-time (in quotation marks) or a date-time sequence number, or a reference to the cell containing one of those types, which is either the start date or the end date of the period for which the calculation is to be carried out.”
(5) Arguments, Date2. Suggest the following replacement text – “Date2 is a date-time (in quotation marks) or a date-time sequence number, or a reference to the cell containing one of those types, which is either the end date or the start date of the period for which the calculation is to be carried out.”
(6) Arguments, second paragraph. Suggest moving this to a bullet point and re-wording as follows – “If Date2 is earlier than Date1, the result is a negative number; if Date2 is later than Date1, the result is a positive number.”.
(7) Arguments, existing bullet. Change “date” to “dates”.
(8) Arguments, new bullet. Insert a statement to reflect that either or both arguments can include time as well as date – for example, “2020-12-08T21:30:00” or 42711.90. In such cases the value returned may include a fractional part.