Hi, I am using a COUNT combined with 2 IF functions, as shown...

{=COUNT(IF(Apr07!$I$10:$I$1001=VALUE("1/4/2007"),IF(Apr07!$J$10:$J$1001="Danielle",Apr07!$I$10:$I$1001)))}

To give you the overview, it's a spreadsheet for time recording email advice at where I work. The advisor will fill in a received time, start time and response sent time (column I). Then there is column J which specifies the name of the advisor. I am counting the date and advisor to show how many emails each advisor has done.
Now this formula does work, but will not work when using the input format of 'dd/mm/yyyy hh:mm'. I'm assuming it's because the IF is just looking for dd/mm/yyyy. Is there anyway in which i can ask the IF to disregard the hh:mm part in column I?

Hope that makes sense, thanks in advance.

Neil