put this into a regular modulethen =if(isadate(g4),1,2)

Function isadate(x)
If isdate(x) Then isadate = True
End Function

--
Don Guillett
SalesAid Software

"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