CountIf not counting...

I am using the current formula

Please Login or Register  to view this content.

The data in column A shows as 1/20/2015, 1:20:21 PM. The Date and time are entered from a userform into Column A.

I tried changing the date in the code above to E1 with no luck. I have tried searching how to manipulate with "&" with no luck.

I would like the formula to be

Please Login or Register  to view this content.

Where E1 is 1/20/2015. E1 is a data validation with mulitple dates as a drop down.

So long story short when I type the date with "*" I am able to get a count. With out the "*" it does not count. Any help would be appreciated.

I'm not sure if that is a proper date/time in A1 or a text value. Try this:

=COUNTIF(A:A, TEXT(E1,"m/dd/yyyy") & "*")

Hope this helps.

Pete

Awesome. Thank you for the help.