Date Function Description

The VBA Date function returns the current system date. The date will be output according to the default system format.

VBA Date Syntax

The syntax for the Date function in VBA is:

Date()

Parameters

The VBA Date function has no parameters.

Other Notes

The format of the date will vary as according to your system settings (locale). Use the Format function

Example usage

The Date function can be used in VBA code. Let’s look at some VBA Date function examples:

Date()
'Result: "2015-10-11"