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.