One way:

=SUMPRODUCT((A1:A8<"")/COUNTIF(A1:A8,A1:A8&""))

Based on your sample the result is 5.

--
Biff
Microsoft Excel MVP


"dj479794" wrote in message
...
(Excel 2003)

I have dates in a column. Some days from start to end are missing and some
show up multiple times. I just want a count of how may days are in the
list
without counting the same date more than once or counting dates that are
not
in the list.


7/1/07
7/2/07
7/2/07
7/2/07
7/4/07
7/4/07
9/13/07
9/15/07....