Date against countifs with multiple line item

Excel Legends,

Data:

Bill No***********Dispatch Date*******Batch NUmber

1848************19/12/2015*********35

1849************19/12/2015*********35

1850************19/12/2015*********35

1859************19/12/2015*********45

1865************19/12/2015*********46

1869************19/12/2015*********46

Required Format:

Date************No of Record Passout

19/12/2015************11


Query-2:

Date***********Starting Number*********End Number

19/12/2015******35********************46


Query-1:

No of records pass out from particular day against multiple line item.

Query-2:

To End of Date staring Batch No and End of Number.

file attached please help me.