View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
audreyglennette
 
Posts: n/a
Default 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?