Counting numbers of date within a spesific month
 

Let say i have this date range:

01.02.2008
01.02.2008
01.02.2008
15.02.2008
29.02.2008
29.02.2008
11.04.2008
02.05.2008
02.05.2008
02.05.2008
02.05.2008
02.05.2008
16.05.2008
16.05.2008
23.05.2008
23.05.2008
23.05.2008
23.05.2008
23.05.2008
23.05.2008
30.05.2008
30.05.2008
06.06.2008
06.06.2008
20.06.2008
20.06.2008
20.06.2008
20.06.2008
20.06.2008

How do i count how many registrations I have in feb.08, march.08 etc???

Counting numbers of date within a spesific month
 

Hi,

Those dates look very suspicious to me but on the assumption they are dates
then try this

=SUMPRODUCT(--(MONTH(A1:A20)=2))

the 2 is February so change as required.

Mike

"Kriss" wrote:

Let say i have this date range:

01.02.2008
01.02.2008
01.02.2008
15.02.2008
29.02.2008
29.02.2008
11.04.2008
02.05.2008
02.05.2008
02.05.2008
02.05.2008
02.05.2008
16.05.2008
16.05.2008
23.05.2008
23.05.2008
23.05.2008
23.05.2008
23.05.2008
23.05.2008
30.05.2008
30.05.2008
06.06.2008
06.06.2008
20.06.2008
20.06.2008
20.06.2008
20.06.2008
20.06.2008

How do i count how many registrations I have in feb.08, march.08 etc???

Counting numbers of date within a spesific month
 

I forgot to mention that I also need to sort them by year. As the list goes
on until 2013. What should I add to the formula to manage this?

Counting numbers of date within a spesific month
 

Try

=SUMPRODUCT(--(MONTH(A1:A20)=2),--(YEAR(A1:A20)=2008))

Mike

"Kriss" wrote:

I forgot to mention that I also need to sort them by year. As the list goes
on until 2013. What should I add to the formula to manage this?