See if this will get you started...
L M N O P Q 1Unpark Conf. In Transfer Out 2 10/7/2015 6 1 2 1 2
M2=COUNTIFS($A:$A,">="&$L2,$A:$A,"<"&$L2+1,$D:$D,M$1)
copied across
You can use the same method to count between date ranges
M3=COUNTIFS($A:$A,">="&$L2,$A:$A,"<="&$L3+1,$D:$D,M$1)
Bookmarks