Count with date range

[Memar]

I want to modify the formula below and consider a date range


[FONT=&quot]Count cell number in column D from January 1,2017 – March 30 2017.
[/FONT]
[FONT=&quot]Count blank cells in Column E from the cell number January 1, 2017 – March 30, 2017 in column D
[/FONT]
[FONT=&quot]Count if cells in column E is greater then zero – Range is the January 1,2017 – March 2017 in column D
[/FONT]
[FONT=&quot]
[/FONT]
[FONT=&quot]

Column A	Column B	Column C	Column D	Column E	Column F
January 1, 2017	March 1 2017	5	January 1, 2017
		3	January 15, 2017
		2	February 1, 2017	0
			February 28, 2017	0
			March 1, 2017	0

<tbody class="SCXW218393996" style="margin: 0px; padding: 0px; user-select: text; -webkit-user-drag: none; -webkit-tap-highlight-color: transparent;">
</tbody>

[/FONT]
[FONT=&quot]
[/FONT]
[FONT=&quot]A formula needs to be modified in the date range in cell C1 = Count (D1:D5) Result = 5
[/FONT]
[FONT=&quot] =Countblank(E1:E5)+CountIF(E1:E5,">0") Result = 3
[/FONT]
[FONT=&quot]
[/FONT]
[FONT=&quot]I want to put the date ranges in Cell A1 and B1
[/FONT]

Thanks for you time and help

 

[Aladin Akyurek]

Clarification needed:

Problem description stipulates January 1, 2017 - March 30, 2017, yet B1 = March 1, 2017.

=COUNTBLANK(E1:E5)+COUNTIF(E1:E5,">0")

should give 2, not 3, for the data you have.