Count if in a range between dates

I'm looking the best way to count the number of people in a specific day given a range of dates. Attached is a file with the data and explanation.

Thanks for your help!

Try this:

Put this formula in L2: =COUNTIFS($C$2:$C$16,L$1,$D$2:$D$16,"<="&$K2,$E$2:$E$16,">="&$K2)

Then copy it across in M2, N2 and O2. Then fill down as far as you need to go.

- Moo

See attached

Edit: Fast fingers MOO!

Fast fingers, indeed. I am a twin. If I had slow fingers I would have never eaten as a child.

- Moo