Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 5
Default 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???
  #2   Report Post  
Posted to microsoft.public.excel.misc
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???

  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 5
Default 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?
  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 11,501
Default 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?

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Counting fileterd cells with spesific value Sjur Excel Worksheet Functions 4 October 1st 08 03:11 PM
return sporadic numbers in a cell-area from a spesific number farmer Excel Worksheet Functions 4 March 26th 08 01:48 PM
Counting the number of date entries in a giving month Philgr Excel Discussion (Misc queries) 4 August 22nd 06 10:55 PM
Date arithmetic: adding 1 month to prior end of month date manxman Excel Worksheet Functions 2 July 14th 06 09:29 PM
counting date entries by month & year Di Excel Worksheet Functions 7 August 24th 05 08:39 PM


All times are GMT +1. The time now is 10:39 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"