Unfortunately this is not straightforward.

isdate(range) will return a true or false depending on whether the cell
contents look like a date.

But remember a date in excel is only a format applied to a number. so
from the data it is not possible to distinguish between a date and a
number. There is a further confusion possible in that you can have text
that looks like a date but is not a number.

hope this helps


--
tony h
------------------------------------------------------------------------
tony h's Profile: http://www.excelforum.com/member.php...o&userid=21074
View this thread: http://www.excelforum.com/showthread...hreadid=562744