1/31/2024 0 Comments Err 502 openofficeIf Interval does not match one of the six expected strings, then DATEDIF reports an invalid argument error (Err:502).If Start date is later than End date, then DATEDIF reports an invalid argument error (Err:502).If either Start date or End date is not a valid date expression, then DATEDIF reports an invalid argument error (Err:502).Number of days between the two dates, ignoring years. Number of days between the two dates, ignoring years and months. ![]() Number of months between the two dates, ignoring years. The accepted strings are listed in the following table and they are not case sensitive (so, for example, "d" and "D" are equivalent). Interval is a string, or a reference to a cell containing that string, which determines which result is returned. End date must not be earlier than Start date. Start date is the date (in quotation marks) or a date-time serial number, or a reference to the cell containing one of those types, which is the start date of the period for which the calculation is to be carried out.Įnd date is the date (in quotation marks) or a date-time serial number, or a reference to the cell containing one of those types, which is the end date of the period for which the calculation is to be carried out. Returns a non-negative integer which is the difference between the two given dates in days, months, or years (as specified in the Interval argument). Determines the difference between two given dates, returning the result in days, months, or years as specified in the third argument.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |