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:

[TABLE="class: grid, width: 100"]
<tbody>[TR]
[TD]Date[/TD]
[/TR]
[TR]
[TD]2/5/18[/TD]
[/TR]
[TR]
[TD]18/5/18[/TD]
[/TR]
[TR]
[TD]2/3/18[/TD]
[/TR]
[TR]
[TD]15/4/18[/TD]
[/TR]
[TR]
[TD]3/6/18[/TD]
[/TR]
[TR]
[TD]Hold[/TD]
[/TR]
[TR]
[TD]4/7/18[/TD]
[/TR]
</tbody>[/TABLE]


[TABLE="class: grid, width: 100"]
<tbody>[TR]
[TD]Dates[/TD]
[TD]Jan 18[/TD]
[TD]Feb 18[/TD]
[TD]Mar 18[/TD]
[TD]Apr 18[/TD]
[TD]May 18[/TD]
[TD]Jun 18[/TD]
[TD]Jul 18[/TD]
[/TR]
[TR]
[TD]Count[/TD]
[TD][/TD]
[TD][/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD]2[/TD]
[TD]1[/TD]
[TD]1[/TD]
[/TR]
</tbody>[/TABLE]

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!