Then your dates are not Excel dates but text so you can't really use a less
than condition
Btw, the second formula should not return a ref error unless copied and
pasted incorrectly, it should return zero since the dates are not numerical.
To use the formulas you must use "real" dates that Excel understand as
numbers in O1351:O1364


--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com


"audreyglennette" wrote in
message ...
This one returns a #VALUE! error:
=COUNTIF('All Employees'!O1351:O1364,""&DATE(2005,12,31))-COUNTIF('All
Employees'!O1351:O1364,"="&DATE(2006,2,1))

This one retuens a #REF! error:
=SUMPRODUCT(--('All Employees'!O1351:O1364--"2005-12-31"),--('All
Employees'!O1351:O1364<--"2006-02-01"))

Any other ideas? Please?