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

=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