Hi,

I am importing a series of data from a database that includes dates and a timestamp. I don't really care about the timestamp.

One sheet has the imported data and data in the "timeout" column has a value like: "6/28/2012 4:18:17 PM"

On another sheet I am trying to count how many data entries there are for a specific date. The data in the comparison cell looks like: "6/28/2012"

I have tried a variety of COUNTIF statements, including:
=COUNTIF('IMPORTED DATA'!E:E,A2&"*")

None seem to be working for me. All attempts have yielded a value of 0. When I can see that the value should be greater.

Any guidance is appreciated.