Home » VBA-Functions » VBA-Date-Function

The VBA DATE Function

Related Functions:
VBA Time
VBA Now

Description

The VBA Date Function simply returns the current date. The function takes no parameters and therefore, its syntax is:

Date( )

VBA Date Function Example

A simple example of the VBA Date function is shown below:

' Store the current date in the variable currDate
Dim currDate As Date
currDate = Date( )

After running the above VBA code, the variable currDate is set to the current date.



Return to the VBA Functions Page
Return to the Excel VBA Tutorial Page