There is no way to tell if the cell value is a date (at least not full
proof)
an excel date is a number so you can test for ISNUMBER and ISTEXT thus the
IS functions are the way to go

=IF(ISNUMBER(A1),"do this","do that")
--

Regards,

Peo Sjoblom

"sparx" wrote in
message ...

The IS command does not perform the function needed as there must be
another way of working it out.


--
sparx
------------------------------------------------------------------------
sparx's Profile:
http://www.excelforum.com/member.php...o&userid=16787
View this thread: http://www.excelforum.com/showthread...hreadid=488775