Hi!

If you want the count of ALL dates:

=COUNT(A1:A50)

If you want the count of unique dates:

1-Jan
1-Jan
1-Jan
5-Jan

Result would be 2:

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

Biff

"beechum1" wrote in
message ...

in a given range, a1:a50, if i have 5,4,3,2 or 1 different date,
(formatted as 1-Jan if relevent) I want to know how many different
dates there are.

1-Jan
2-Jan
3-Jan
5-Jan
for instance would return a value of 4

1-Jan
5-Jan
would return a value of 2.

I just don't know what statement to even start with.....


--
beechum1
------------------------------------------------------------------------
beechum1's Profile:
http://www.excelforum.com/member.php...o&userid=30489
View this thread: http://www.excelforum.com/showthread...hreadid=511438