Count between 2 dates

Originally Posted by 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

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