XLL+ Class Library (7.0)


Transform a string to a serial date

int XlStringToLSerial(
   const char* str,
   long* date
int XlStringToLSerial(
   const wchar_t* str,
   long* date



A string containing a date. Excel will use the date formatting rules currently in force to read the string.


Pointer to a variable which will be filled with a serial date value (as used by Excel).

Return Value

1 if the function succeeds; 0 if it fails


This function calls Excel's DATEVALUE() function to transform a string date into its components.

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


Header: xlldate.h

See Also

Global date functions