how to make relation counting in excel?

I have a table with employees, id, name, date and time they attend and leave like this:

http://ift.tt/1RfI2RX

What i need now is to make a new table based on the old table to count how many employee attended on each date. I did something, using an if statement, like this:

=IF(B2=total!C:C;COUNT(total!D2:D154)) 

But it doesn't work some times.

Please does anyone have any ideas please help?