I thought the OP might want to check Text representations as well.

--
Rick (MVP - Excel)



"Gary''s Student" wrote in message
...
Any cell with an integer value between 0 and 2958465 can, with proper
formatting, represent a date.
--
Gary''s Student - gsnu201002


"Bishop" wrote:

Is there a way I can check to see if a cell value has a date value... in
any
format?