XLL+ Class Library (7.0)

::XlLSerialToDate

Transform an integer Excel serial date to year, month and day

int XlLSerialToDate(
   long date,
   int* yy,
   int* mm,
   int* dd
);

Parameters

date

An integer serial date value.

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