Count a number of completed events happened in a day

[tg0809]

I have a bunch of data in the following format:
Time From Time To
05/08/17 19:25 05/08/17 21:39
05/08/17 22:30 05/09/17 00:30
05/09/17 01:04 05/09/17 02:57
05/09/17 06:27 05/09/17 06:32
05/09/17 06:32 05/09/17 08:28
05/09/17 11:51 05/09/17 13:48
05/09/17 17:00 05/09/17 18:54
05/09/17 23:18 05/10/17 00:00

How can i count a number of completed events in a day? (midnight to midnight)
So, if the event started in 1 day and finished on another- don't count it.
Thank you for your help

[Richard Buttrey]

Probably by adding a helper column that determines whether the Time To date is the same as the Time From date and then using a Pivot Table to analyse the data and use a SLicer to filter the completed records.

If you want further help then upload the workbook.

[63falcondude]

Try

=COUNT(IF(ROUNDDOWN(A2:A9,0)=ROUNDDOWN(B2:B9,0),A2:A9)) Ctrl Shift Enter

[tg0809]

Thank you
But I need a count per day
so more like:
Date Count
05/08/2017 1
05/09/2017 2
05/10/2017 1

[63falcondude]

Thank you
But I need a count per day
so more like:
Date Count
05/08/2017 1
05/09/2017 2
05/10/2017 1

With a unique list of dates in column D, you can write this formula in column E (starting in E2):

=COUNTIFS(A:A,">="&D2,B:B,"<="&D2+0.99999)

[Richard Buttrey]

...as suggested in post #2 please upload the workbook. It's important to see your data in context.