Transform an Excel serial date to year, month and day
int XlSerialToDate( double date, int* yy, int* mm, int* dd ); |
A serial date value as used by Excel.
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