Count between 2 dates

[ruenell]

I need to be able to do a count between two dates in a single count

all items that are between 03/01/2011 and 03/31/2011

I just cant seem to get the logic to work correctly.

I am using Excel 2010

I need this pretty quick and appreciate your fast response!!

Dorinda

[scottylad2]

I need to be able to do a count between two dates in a single count

all items that are between 03/01/2011 and 03/31/2011

With your Dates in A1:A31 and the item your looking to count is say Pat

COUNTIFS(A1:A31,">="&DATE(2010,3,1),K3:K22,"pat",A1:A31,"<="&DATE(2010,3,31),K3:K22,"pat")

will let you count a specific item that shows between the 2 dates