Countif for dates that exclude a value

[churmie]

Morning guys.

A simple one, that is getting me confused. I need to count certain dates but exclude a value. How could I do this? An example is below:

Date

2/5/18

18/5/18

2/3/18

15/4/18

3/6/18

Hold

4/7/18

<tbody>
</tbody>

Dates	Jan 18	Feb 18	Mar 18	Apr 18	May 18	Jun 18	Jul 18
Count			1	1	2	1	1

<tbody>
</tbody>

I need to get the formula in the 'Count' row. I know it seems simple, but I'm obviously doing something wrong! Thanks for the help in advance as always!

Churmie

 

[wideboydixon]

Book1
	A	B	C	D	E	F	G	H
1	Date
2	02/05/2018
3	18/05/2018
4	02/03/2018
5	15/04/2018
6	03/06/2018
7	Hold
8	04/07/2018
9
10	Dates	Jan-18	Feb-18	Mar-18	Apr-18	May-18	Jun-18	Jul-18
11	Count	0	0	1	1	2	1	1
Sheet1

Cell Formulas
Range	Formula
B11	=COUNTIFS($A$2:$A$8,">="&B$10,$A$2:$A$8,"<="&EOMONTH(B$10,0))

WBD

 

[churmie]

perfect WBD! Great help!