Formula to count between 2 numbers matching month

[umirin]

hi all need help with a formula that can count between 2 numbers and match month you can see my current formulas are done manually just seeing if there is an easier way.

=COUNTIFS($B$2:$B$7,">2",$B$2:$B$7,"<5")
Current formula i'm using in F4


Excel 2016 (Windows) 32 bit

	A	B	C	D	E	F
1	Date	Change
2	Friday, 1 January 2016	2.00
3	Saturday, 2 January 2016	4.00			Date	Over 2 but Under 5
4	Sunday, 3 January 2016	1.00			Janurary	3
5	Monday, 4 January 2016	3.00			March	2
6	Tuesday, 5 January 2016	5.00			July	4
7	Wednesday, 6 January 2016	4.00
8	Tuesday, 1 March 2016	7.00
9	Wednesday, 2 March 2016	3.00
10	Thursday, 3 March 2016	6.00
11	Friday, 4 March 2016	9.00
12	Saturday, 5 March 2016	4.00
13	Sunday, 6 March 2016	2.00
14	Wednesday, 13 July 2016	8.00
15	Thursday, 14 July 2016	3.00
16	Friday, 15 July 2016	7.00
17	Saturday, 16 July 2016	3.00
18	Sunday, 17 July 2016	5.00
19	Monday, 18 July 2016	2.00
20	Tuesday, 19 July 2016	3.00
21	Wednesday, 20 July 2016	4.00
22	Thursday, 21 July 2016	7.00

Sheet: test

[Pete_UK]

Assuming those are proper dates in column A, then in E4:E6 you should also put dates, i.e. 1/01/16, 1/03/16 and 1/07/16 and format the cells using a custom format of mmmm so that they look the same. Then you can use this formula in F4:

=COUNTIFS(B:B,">2",B:B,"<5",A:A,">="&E4,A:A,"<="&EOMONTH(E4,0))

and copy it down.

Hope this helps.

Pete