B
Bishop
Is there a way I can check to see if a cell value has a date value... in any
format?
format?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
R
Rick Rothstein
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
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
G
Gary''s Student
Any cell with an integer value between 0 and 2958465 can, with proper
formatting, represent a date.
formatting, represent a date.
R
Rick Rothstein
I thought the OP might want to check Text representations as well.
G
Gary''s Student
You may be right. I didn't think of that.