Transform an integer Excel serial date to year, month and day
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