=COUNTIF(A:A,"05/05/2005")
or, put 05/05/2005 in cell F1 and use this........
=COUNTIF(A:A,F1)
Then all you have to do is change F1 if you want to count another
date..........
Vaya con Dios,
Chuck, CABGx3
"DLZ217" wrote in message
...
I can't seem to figure out how to count the number of times a date shows
up
in a column, the data is entered in this format 05/05/2005 for instance
and
when I type that date I want to count it defaults to 5/5/2005 so I tried
to
change the original data to that format but it still doesnt seem to work,
any
ideas? Thanks!!
Mike
|