View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Mike H Mike H is offline
external usenet poster
 
Posts: 11,501
Default 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???