Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Counting fileterd cells with spesific value | Excel Worksheet Functions | |||
return sporadic numbers in a cell-area from a spesific number | Excel Worksheet Functions | |||
Counting the number of date entries in a giving month | Excel Discussion (Misc queries) | |||
Date arithmetic: adding 1 month to prior end of month date | Excel Worksheet Functions | |||
counting date entries by month & year | Excel Worksheet Functions |