XLL+ Class Library (7.0)

xlldate.h

Overview

xlldate.h contains some global functions that access Excel's native date functionality and a class CXlDate which offers the same functionality in a more convenient form.

Classes

The table below lists the C++ object classes declared in the header file.

Class Description
CXlDate Static class containing date helper functions.

Functions

The table below lists the principal functions declared in the header file.

Function Description
XlSerialToDate Transform an Excel serial date to year, month and day.
XlDateToSerial Transform year, month and day to an Excel serial date.
XlLSerialToDate Transform an integer Excel serial date to year, month and day.
XlDateToLSerial Transform year, month and day to an Excel serial date.
XlStringToDate Transform a string to year, month and day.
XlStringToSerial Transform a string to a serial date.
XlStringToLSerial Transform a string to a serial date.
XlToday Get today's date.
XlNow Get the current time.
XlWeekday Convert a date to a day of the week.

A full list can be found here.