how get many days in March repeate in column have many dates
 

i have a cloumn have many dates. i would like to know how many days repeated
in january, February and March for example

how get many days in March repeate in column have many dates
 

This counts the number of repeated items for March

=SUMPRODUCT(--(MONTH(A1:A20)=3))-SUMPRODUCT((A1:A20<"")/COUNTIF(A1:A20,A1:A20&""))

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)



"Wael Adel" <Wael wrote in message
...
i have a cloumn have many dates. i would like to know how many days
repeated
in january, February and March for example