DateSerial

Constructs a date value from the given Year, Month, and Day arguments passed to the function. The DateSerial function expects all three parameters to be valid. Date values in VBA are evaluated using the Gregorian Calendar.

Syntax

DateSerial(year,month,day)

year, month, day:

The year, month and day as integers.

Return Value

Returns a Variant (of date data type) containing a date value corresponding to the Year, Month and Day values that were passed in to the function.

Related Functions

TimeSerial

Example

Dim varMyBDate
varMyBDate = DateSerial(1958, 7, 08)
' constructs and stores date value.