Excel DATE & ISDATE VBA Function
The Excel Data function is a simple Excel VBA function that will return the current date. You can also use the function to identify if a variable is a date format.
GetDate = Date()
'GetDate would equal something like 11/12/2010
To verify if a variable is a date, you could use the formula ISDATE()
ISDATE will product a true or false result.
Dim getdate As Date
getdate = "1/2/2010"
If IsDate(getdate) = True Then
MsgBox "The data is an actual date"
This result is true as getdate is an actual date.