The VBA DATE Function

Home » Excel-VBA-Tutorial » VBA-Operators-And-Functions » VBA-Date-Function

Search this site:

Custom Search

Related Function:

VBA TIME function

Description

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

Date()

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

Dim CurrDate As Date
CurrDate = Date( )

After running the above snippet of VBA code, the variable 'CurrDate' is set to the current date.

Disclaimer