Can I Count dates without repeating?

B

bogdan77

I am trying to count dates column without repeating every date twice.
For Example:
08/10/05
08/10/05
08/11/05
08/11/05
08/11/05

Answer should be 2.

Is it possible in Excel?

Thank you for your time
 
D

Duke Carey

This is an array formula, committed with Ctrol-Shift-Enter. Assumes you
dates are in cells A1:A10

=SUM(1/COUNTIF(A1:A10,A1:A10))
 
Top