VBA-Excel: Date-Time Functions – IsDate()

Description: 

The IsDate() function determines whether expression can be converted into date and  returns the Boolean value based upon that.

Format:

IsDate(expression)

Arguments:

• expression
  • Mandatory
  • Validate whether expression can be converted into date.

Example:

Function FnIsDate()

   Dim strDate

   Dim strInvalidDate

   strDate = "12-July-2013"

   strInvalidDate = "12000-11-1111111"

   MsgBox "'12-July-2013' can be converted into Type Date: " & IsDate(strDate) & vbCrLf & "'12000-11-1111111' can be converted into Type Date: " & IsDate(strInvalidDate)

End Function

Also Read:

1. VBA-Excel: String Functions – Replace()
2. VBA-Excel : 3D-Ranges – FillAcrossSheets Method
3. VBA Excel – Looping Through a Range of Cells
4. VBA-Excel : 3D-Ranges - Working with Multiple WorkSheets At The Simultaneously
5. VBA-Excel: Array Functions – Join() – Converts Array to String
6. VBA-Excel: String Functions – Trim()
7. VBA-Excel: Date-Time Functions – Hour(), Minute(), Second()
8. VBA-Excel: Fill Excel Range Values in a 2D Array