XLL+ Class Library

::XlSerialToDate

Transform an Excel serial date to year, month and day

[C++]
int XlSerialToDate(
   double date,
   int* yy,
   int* mm,
   int* dd
);

Parameters

date

A serial date value as used by Excel.

yy

Pointer to variable which will contain year (eg 1996).

mm

Pointer to variable which will contain month (1-12).

dd

Pointer to variable which will contain day of month (1-31).

Return value

1 if the function succeeds; 0 if it fails

Remarks

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.

Requirements

Header: xlldate.h

See Also

Global date functions