DateSerial Function

Syntax:

DateSerial(Year, Month, Day)

Group:

Time/Date

Description: 

Returns a date value.

Parameters:

Parameter

Description

Year

his numeric value is the year (0 to 9999). (0 to 99 are interpreted by the operating system.)

Month

This numeric value is the month (1 to 12).

Day

This numeric value is the day (1 to 31).

Example:

Sub Main
  Debug.Print DateSerial(2000,7,4) '7/4/2000
End
Sub