Using COUNTIFS to count DATE?

[russ101]

I have all kinds of data and a lot of columns with lots of formulas to calculate different metrics, now I am concern with three columns of data particularly that I am trying to count to see how long a job in 01/25/2011 in category 4 took 3 hours to complete, and then another job in 02/21/2011 in category 3 took 5 hours to complete. So basically here is the data format.

A1. Any number between 1 - 10 (Categeories)
B1. Dates and Time -1/10/2011 14:48 (YTD Data)
C1. Duration - 6.30 Business hours (Came up from another formula)

Theorotically, I am trying to read the data in this manner

=COUNTIFS(B1:B5000,">=01/31/2011",'A10:A5000,"=3",C10:C5000,"<=.5")

it is nto giving me the right number, I am not surre how to capture the date

 

[VoG]

Try

=COUNTIFS(B1:B5000,">="&"01/31/2011"+0,A10:A5000,3,C10:C5000,"<="&0.5)

 

[russ101]

Thanks a lot for your help - however, "<="&"01/31/2011"+0 didn't count all the cell that has 01/31/2011 date, somehow it counts only the date less than 01/31/2011. But I fixed it by specifying 02/01/2011 and it counted all the date up to 01/31/2011.

One more questions, how would you tell this formula to compare 2 dates to get the data? For instance, if I am looking at the column of YTD data and want to have a separate count for all of January, February, March with the other criteria remains the same(A10:A5000,3,C10:C5000,"<="&0.5)