Counting Cells with certain date ranges as values
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?
|