Using Countif with Dates

I can't figure out this simple task.. counting the # of orders by date.

I've attached a workbook to illustrate

I very much appreciate your patient help!

What about a simple pivot table?

How about

=COUNTIF($C$3:$C$15,D3)

Try the following formula (advantage: no need to have the RoundDown column):

=COUNTIFS(B$3:B$15,">="&D3,B3:B15,"<"&D4)

Thanks everyone. I appreciate your help.