Transform an integer Excel serial date to year, month and day
[C++]
int XlLSerialToDate(
long date,
int* yy,
int* mm,
int* dd
);
An integer serial date value.
Pointer to variable which will contain year (eg 1996).
Pointer to variable which will contain month (1-12).
Pointer to variable which will contain day of month (1-31).
1 if the function succeeds; 0 if it fails
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.
Header: xlldate.h