Use
VB's IsDate function. For example...
If IsDate(Range("A1").Value) Then
' A1 contains something
VB can interpret as a date
Else
' The contents of A1 does not look like a date to
VB
End If
--
Rick (MVP - Excel)
"Bishop" wrote in message
...
Is there a way I can check to see if a cell value has a date value... in
any
format?