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.

For Example:

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"

End If

This result is true as getdate is an actual date.