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