TOEXCELDATE

The TOEXCELDATE function converts an input date to a serial number that Excel recognizes as a date. The input date should be in MM/DD/YYYY format. Node references are also accepted as arguments.

Syntax

toexceldate(date)

Arguments

date - The input date which is to be converted into an excel sequential serial number.

Return value

Number

Example

toexceldate('8/15/2023')

Returns 45153.

Converts date to EXCEL serial number