Try the below

=SUMPRODUCT((Y1:Y100<"")/COUNTIF(Y1:Y100,Y1:Y100&""))

If cell Y1 is header then adjust the range as Y2:Y100

If this post helps click Yes
---------------
Jacob Skaria


"driller2" wrote:

helllo again,

i a have a "Y" column of date entry.

Most of dates are repeated, some are entered once.

I need to count only the number of dates (excldg repetitions).

example
15-Sep-09
22-Sep-09
20-Oct-09
20-Oct-09
20-Oct-09
22-Oct-09

From above 6 dates; the unique count should be 4.

thanks