Inventory reconstruction in Excel from list of unique product inventory states and timestamps

id status date time a received 01-Jan-14 04:00 a available 05-Jan-14 05:00 a returned 06-Jan-14 13:00 a destroyed 07-Jan-14 12:00 b received 10-Jan-14 14:00 b available 11-Jan-14 08:00 b returned 12-Jan-14 09:00 b destroyed 13-Jan-14 07:00 c received 02-Jan-14 05:00 c available 03-Jan-14 07:00 c returned 05-Jan-14 08:00 d received 09-Jan-14 02:00 d available 12-Jan-14 06:00 (etc)

I have unique ids, each with a state and a date. for a given date, I need to count the 'available' ones. For a given date, I need to count the 'received' ones. I intend to input a date and time in a given cell and do those counts based on that date and time. How do I do this as an Excel formula?

i.e. January 3, 2014 06:00, there are 2 received and 0 available widgets [a is received, not available yet; c received but not available yet]

Your help is appreciated!