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