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))



"bogdan77" wrote:


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.


--
bogdan77
------------------------------------------------------------------------
bogdan77's Profile: http://www.excelforum.com/member.php...o&userid=26204
View this thread: http://www.excelforum.com/showthread...hreadid=395112