Which Function to be used??
 

Hi All,

I have a sample data,
eg:
11/01/2012
11/01/2012
11/07/2012
11/07/2012
11/07/2012
11/07/2012
11/20/2012
11/20/2012
11/20/2012
11/20/2012

I want to know how many counts in November, not by Date. My Output should say as "11" for the above example.

I have the excel spreadsheet for your kind reference.

Regards,
Asrar Ayub

Which Function to be used??
 

Hi,

Am Mon, 21 Jan 2013 07:25:09 +0000 schrieb Asrar Ayub:

11/01/2012
11/01/2012
11/07/2012
11/07/2012
11/07/2012
11/07/2012
11/20/2012
11/20/2012
11/20/2012
11/20/2012

I want to know how many counts in November, not by Date. My Output
should say as "11" for the above example.

you can do it with pivot table. Drag the dates into rows and into
values. Group the dates in the rows by month.
Or use in D4:
=IF(MONTH(C5)=MONTH(C4),"",SUMPRODUCT(--(MONTH($C$4:$C$100)=MONTH(C4)),--($C$4:$C$100<"")))
and copy down


Regards
Claus Busch
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2

What do you mean by "not by Date"?
If you're counting dates, you need to involve dates....