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]
[TABLE="class: Table TableWordWrap SCXW218393996, width: 0"]
<tbody class="SCXW218393996" style="margin: 0px; padding: 0px; user-select: text; -webkit-user-drag: none; -webkit-tap-highlight-color: transparent;">[TR="class: TableRow TableRowSelected"]
[TD="bgcolor: transparent"]Column A


[/TD]
[TD="bgcolor: transparent"]Column B


[/TD]
[TD="bgcolor: transparent"]Column C


[/TD]
[TD="bgcolor: transparent"]Column D


[/TD]
[TD="bgcolor: transparent"]Column E


[/TD]
[TD="bgcolor: transparent"]Column F


[/TD]
[TD="bgcolor: transparent"]


[/TD]
[/TR]
[TR="class: TableRow TableRowSelected"]
[TD="bgcolor: transparent"]January 1, 2017


[/TD]
[TD="bgcolor: transparent"]March 1 2017


[/TD]
[TD="bgcolor: transparent"]5


[/TD]
[TD="bgcolor: transparent"]January 1, 2017


[/TD]
[TD="bgcolor: transparent"]


[/TD]
[TD="bgcolor: transparent"]


[/TD]
[TD="bgcolor: transparent"]


[/TD]
[/TR]
[TR="class: TableRow TableRowSelected"]
[TD="bgcolor: transparent"]


[/TD]
[TD="bgcolor: transparent"]


[/TD]
[TD="bgcolor: transparent"]3


[/TD]
[TD="bgcolor: transparent"]January 15, 2017


[/TD]
[TD="bgcolor: transparent"]


[/TD]
[TD="bgcolor: transparent"]


[/TD]
[TD="bgcolor: transparent"]


[/TD]
[/TR]
[TR="class: TableRow TableRowSelected"]
[TD="bgcolor: transparent"]


[/TD]
[TD="bgcolor: transparent"]


[/TD]
[TD="bgcolor: transparent"]2


[/TD]
[TD="bgcolor: transparent"]February 1, 2017


[/TD]
[TD="bgcolor: transparent"]0


[/TD]
[TD="bgcolor: transparent"]


[/TD]
[TD="bgcolor: transparent"]


[/TD]
[/TR]
[TR="class: TableRow TableRowSelected"]
[TD="bgcolor: transparent"]


[/TD]
[TD="bgcolor: transparent"]


[/TD]
[TD="bgcolor: transparent"]


[/TD]
[TD="bgcolor: transparent"]February 28, 2017


[/TD]
[TD="bgcolor: transparent"]0


[/TD]
[TD="bgcolor: transparent"]


[/TD]
[TD="bgcolor: transparent"]


[/TD]
[/TR]
[TR="class: TableRow TableRowSelected"]
[TD="bgcolor: transparent"]


[/TD]
[TD="bgcolor: transparent"]


[/TD]
[TD="bgcolor: transparent"]


[/TD]
[TD="bgcolor: transparent"]March 1, 2017


[/TD]
[TD="bgcolor: transparent"]0


[/TD]
[TD="bgcolor: transparent"]


[/TD]
[TD="bgcolor: transparent"]


[/TD]
[/TR]
</tbody>[/TABLE]

[/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.