Can I convert this one easily to have it show the number of times a specific
day DOES repeat? Endresult shoud look like this:
Column1.....Column2
6/17/2006...2
5/24/2006...1
4/6/2006.....5
etc.

"Bob Phillips" wrote:

=SUMPRODUCT((A1:A200<0)/COUNTIF(A1:A200,A1:A200))

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"SouthCarolina" wrote in message
...
I am trying to count dates in a column that do not repeat. For example

3/12/2006
3/14/2006
4/1/2006
4/1/2006
4/12/2006
0
0

I want the count function to return "4" as the number of entries.
Basically, I want it to exclude zeros and repeating dates. Do you have
any
suggestions?