On 23 Feb, 07:00, "manish" wrote:
Hi All,

How could i count the number of identical dates in a column ?

Thanks in advance.

Rgds,
Msh.

I do not know exactly what you have on your mind but from what
I understand you'd like to be able to do this:

Precondition: You have a column range in which there are dates.
Say the range is named myRange (= A1:A100 for the sake of
argument). Then you have a range named myDate (=B1).
You want a formula to count the number of occurences of myDate
in myRange.

There are two ways:
1. The countif function.
2. Array formula.

1.) =countif(myRange, myDate)
2.) =sum(if(myRange = myDate, 1, 0)) and you have to press
CTRL+SHIFT+ENTER.

I don't know whether this is what you wanted.

Darek