VBA Date function

1 Star2 Stars3 Stars4 Stars5 Stars (1 votes, average: 5.00 out of 5)

Date Function Description

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


The syntax for the Date function in VBA is:



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:

'Result: "2015-10-11"

Simply the best place to learn Excel VBA