These docs are for v1.0. Click to read the latest docs for v1.2.

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

ArgumentTypeDescription
valueNumber or DateIf 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