XLL+ Class Library (7.0)

CXlDate::DateToSerial

Transform year, month and day to an Excel serial date

static double DateToSerial(
   int yy,
   int mm,
   int dd
);

Parameters

yy

Year (eg 1996).

mm

Month (1-12).

dd

Day of month (1-31).

Return Value

An Excel serial date value.

Remarks

This function calls Excel's DATE() function to calculate a serial date from its components.

Because it uses Excel for the transformation, it handles variations in the Excel base date transparently.

Exceptions

If a call to the Excel API fails, then an exception of type CXlApiException will be thrown. Since this exception is derived from CXlRuntimeException, it will be caught by the add-in wrapper function when this method is called from within an add-in function.

Requirements

Header: xlldate.h

See Also

CXlDate Class | CXlDate Methods