Can I Count dates without repeating?

[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.

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



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