View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
mommy2kh mommy2kh is offline
external usenet poster
 
Posts: 9
Default Can I Use A Count If Function With A Forward Slash?

I am trying to use a Count If function on a string of data with dates. The
data is downloaded like this --

Column A
Row 1 7/7/2008 1:18:00 PM
Row 2 7/7/2008 12:34:00 AM
Row 3 7/8/2008 5:03:00 PM

I tried setting up my Count If like this to count how many occurances there
are of the date July 7, but it isn't working --

=COUNTIF(A:A,"7/7/2008*")

Is it not working because of the forward slashes? I can change the format
of the cells to show "Jul-07 x:xx:xx PM" but I cannot get the actual data to
change to help me with the Count If function. Any ideas?