EXCELDATE
This function is intended to create a date from a numeric Excel date value, assuming the value is stored as the number of days since Dec 30, 1899 (where 1 is 12/31/1899). Sometimes our system has already converted the Excel date value into Lucid's existing Date object, in which case we simply pass that date through unchanged.
Syntax
=EXCELDATE(value)
Arguments
| Argument | Type | Description |
|---|---|---|
| value | Number or Date | If value is a date, it gets passed through unchanged. Otherwise it returns the date which is value days after Dec 30, 1899. |
Examples
=EXCELDATE(1)→Dec 31, 1899 12:00 AM
=EXCELDATE(43800)→Dec 31, 2019 12:00 AM
=EXCELDATE(DATE(2019, 01, 01))→Jan 1, 2019 12:00 AM
Updated 8 months ago