Date VBA function – Current date in VBA Excel

Last Updated on January 11, 2023 by token

1. Date VBA function – Description

The Date VBA function   returns the current date. If we want Excel VBA to return the current date, we should use this function. The Date function has no arguments. The date value from the Date function is the system date. You can compare the function to the TODAY () formula in an Excel worksheet. If, in turn, we would like VB to return the current date and time or the time itself, we should use the Now () function, which you can read about in this article: VBA Now .

2. VBA Date function – Syntax


Function return:  Date / System date.

3. VBA Date function – Example

How to use Date function in VBA Excel? Below is an example of using the Date function in the VisualBasic Editor.

Example 1:

Dim DatExample As Date
DatExample = Date
MsgBox DatExample

Example 2:

Range ("A1") = Date
Excel VBA functions - Date VBA function
Excel VBA functions – Date VBA function

4. VB Date function – Additional information

  • If we want to enter the date obtained from the Date function into an Excel sheet, we will get a number representing the date in Excel. To avoid this, the date in VBA should be entered into a variable of the string type, or the result of the Date function should be converted using the CStr function .

5. Date VisualBasic function – Where to use?

The function can be used in: Excel 2003, Excel 2007, Excel 2010, Excel 2013, Excel 2016, Excel 2019, Excel 2021, Excel 365.

The article is part of the VBA Excel function list. You can find a list of all VBA functions at this address:  VBA functions.

Leave a comment

Your email address will not be published. Required fields are marked *

%d bloggers like this: