Search notes:

VBA: dateSerial() and timeSerial()

dateSerial(year, month, day) constructs a date from the three integers year, month and day.
timeSerial(hr, mi, ss) creates a time (of datatype date) whose hour is hr, minute is mi and second is ss.
By combining dateSerial and timeSerial, it's possible to construct any VBA date from its six components. This is demonstrated in the function UTCStringToDate().

See also

VBA Date literals

Index