Countif not counting date correctly

Hi.

I am using the following code:

Please Login or Register  to view this content.

In Cell E1 I am using

Please Login or Register  to view this content.

When I type in todays date into a cell in column A the formula doesn't count. However, the formula will begin counting later on in the month. Any idea why the formula wouldn't count at the beginning of the month?

The format of how the date gets entered is 3/3/2015, 4:08:08 PM. This is entered off a userform.

Thoughts?

If the format in column A:A are date & time
Try this formula: =COUNTIFS(A:A, ">=" & E1,A:A, "<" &(E1+1))

if the format in column A:A is text
Try this formula: =COUNTIF(A:A,TEXT(E1,"m/d/yyyy") & "*") : note /d instead of /dd