Because Excel translates dates to numbers, this is a difficult task.

You can try something like:
=SUMPRODUCT(--(A1:D1=DATE(2005,1,1)),--(A1:D1<=DATE(2005,12,31)))

you can change the dates to what would be the earliest possible date
and the latest possible date. Note that the dates are translated as 5
digit numbers. So Jan 1, 2005 is equivalent to 38353 and Dec 1, 2005 is
38691 so as long as you don't have numeric values within that range, the
formula will count dates only.


--
Vito
------------------------------------------------------------------------
Vito's Profile: http://www.excelforum.com/member.php...o&userid=29182
View this thread: http://www.excelforum.com/showthread...hreadid=492293