How do i count date cells without duplicate values in excel?
 

In excel sheet I did type dates some date have duplicate values(means repited
same date) including holidays, without some weekdays. Now i want to count
that entired dates only without duplicate values. Please help me at the
earliest. I am waiting for urs reply.

How do i count date cells without duplicate values in excel?
 

Vasanth,
Should be able to perform a simple countif() function... Any date
returning a value of 1 would be unique.


Vasanth Kumar wrote:
In excel sheet I did type dates some date have duplicate values(means repited
same date) including holidays, without some weekdays. Now i want to count
that entired dates only without duplicate values. Please help me at the
earliest. I am waiting for urs reply.

How do i count date cells without duplicate values in excel?
 

=SUMPRODUCT((A2:A20<"")/COUNTIF(A2:A20,A2:A20&""))

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Vasanth Kumar" <Vasanth wrote in message
...
In excel sheet I did type dates some date have duplicate values(means
repited
same date) including holidays, without some weekdays. Now i want to count
that entired dates only without duplicate values. Please help me at the
earliest. I am waiting for urs reply.