Excel Help Home ExcelHelp.com BBB Business Review
Excel DATE & ISDATE VBA Function

Excel DATE 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.

 
 
Sitemap | Privacy | Terms
Microsoft ® and Microsoft Excel ® are registered trademarks of Microsoft Corporation.
Copyright 2011 ExcelHelp.com All rights reserved
More Info (+)