FROM_EXCELDATE

The FROM_EXCELDATE function converts an Excel serial date number into its equivalent date value. Excel stores dates as sequential serial numbers to support date calculations. This function is commonly used when importing or converting date values from Excel-based data sources.

Syntax

FROM_EXCELDATE(value)

Arguments

• value: The Excel serial date number to convert.

Return value

Returns the corresponding date value.

Example

FROM_EXCELDATE(39457)

Returns 10/01/2008.