Multiple Countifs with date complication

[LRA User]

I want to count the number of occurences involving 3 columns of a spreadsheet, but one of the columns is a date/time field, and I only want to analyse the date.

Example:

A B C
John 1 02/07/2009 09:45:10
Peter 1 03/06/2009 10:14:12
Fred 1
Peter
John 1 02/07/2009 09:45:10

How can I ask how many occurences of John are in column A, with a 1 in column B, with the date 02/07/2009?

 

[LRA User]

I have a new challenge for the same spreadsheet.
One column has a series of date & time fields, and another column has 1 or 0 depending on whether the condition is true or false.

How can I interrogate both columns to determine where the second column has a 1 and the date column equals a specific date only.