Transform an Excel serial date to year, month and day
static void SerialToDate( double date, int& yy, int& mm, int& dd );
A serial date value as used by Excel.
Reference to variable which will contain year (eg 1996).
Reference to variable which will contain month (1-12).
Reference to variable which will contain day of month (1-31).
This function calls Excel's YEAR(), MONTH() and DAY() functions to transform a serial date into its components.
Because it uses Excel for the transformation, it handles variations in the Excel base date transparently.
If a call to the Excel API fails, then an exception of type CXlApiException will be thrown. Since this exception is derived from CXlRuntimeException, it will be caught by the add-in wrapper function when this method is called from within an add-in function.