Analysis using counts of goods between certain dates

[xxsalahxx]

Hello Is it possible to have a piece of analysis for counting how many references fall between the dates 01/01/2013 to 31/01/2013. Then 01/02/2013 to 29/02/2013?
I have 2 columns as you can see below and have approx 5000 rows of data.
January should total up to 6 from my example below and february should total up to 3.
This is from sheet one and im trying to calculate this on sheet 2 if possible?
Thanking you in advance for any help anyone can give to me.

Ref	Date
PP0001	01/01/2013
PP0002	01/01/2013
PP0003	09/01/2013
PP0004	28/01/2013
PP0005	20/02/2013
PP0006
PP0007	19/01/2013
PP0008	23/02/2013
PP0009
PP0010	04/02/2013
PP0011	03/01/2013

<COLGROUP><COL style="WIDTH: 48pt" width=64><COL style="WIDTH: 53pt; mso-width-source: userset; mso-width-alt: 2596" width=71><TBODY>
</TBODY>

 

[Robert Mika]

Hello Is it possible to have a piece of analysis for counting how many references fall between the dates 01/01/2013 to 31/01/2013. Then 01/02/2013 to 29/02/2013?
I have 2 columns as you can see below and have approx 5000 rows of data.
January should total up to 6 from my example below and february should total up to 3.
This is from sheet one and im trying to calculate this on sheet 2 if possible?
Thanking you in advance for any help anyone can give to me.

Ref	Date
PP0001	01/01/2013
PP0002	01/01/2013
PP0003	09/01/2013
PP0004	28/01/2013
PP0005	20/02/2013
PP0006
PP0007	19/01/2013
PP0008	23/02/2013
PP0009
PP0010	04/02/2013
PP0011	03/01/2013

<TBODY>
</TBODY>

Try Pivot Table.

 

[xxsalahxx]

Is there any analysis apart from using pivot tables as this spreadsheet needs to be self analysing for other users? Thank you.

 

[Robert Mika]

Is there any analysis apart from using pivot tables as this spreadsheet needs to be self analysing for other users? Thank you.

Excel 2010
	A	B	C	D	E	F
1	Ref	Date			January	February
2	PP0001	1/1/2013			6	3
3	PP0002	1/1/2013
4	PP0003	1/9/2013
5	PP0004	1/28/2013
6	PP0005	2/20/2013
7	PP0006
8	PP0007	1/19/2013
9	PP0008	2/23/2013
10	PP0009	2/4/2013
11	PP0010	4/2/2013
12	PP0011	1/3/2013
Sheet2

Cell Formulas
Range	Formula
E2	=SUMPRODUCT(--(MONTH($B$2:$B$13)=MONTH(E$1)),--($B$2:$B$13<>""))