count between dates

[jtodd]

Hi all
Is there a way to count non blank cells between 2 dates ?

I have a holiday planner and would like to know how many days holday each person has taken from the start of year to now.
In the example below are the holidays booked , i need to know how many H's are between 23/04/2018 and now ie how many days have been taken -
In this case 7 days have been booked but only 3 between 23/04/2018 and today. Tried this =COUNTIFS(C11:Z11,">="&E4,C11:Z11,"<="&F4) but think i need some kind of offset ? or do i need some thing completly different.

<colgroup><col style="mso-width-source:userset;mso-width-alt:2742; width:56pt" span="12" width="75"> </colgroup><tbody>
[TD="class: xl65, width: 75, align: right"][/TD]
[TD="class: xl65, width: 75, align: right"][/TD]
[TD="class: xl65, width: 75, align: right"][/TD]
[TD="class: xl65, width: 75, align: right"][/TD]
[TD="class: xl65, width: 75, align: right"][/TD]
[TD="class: xl65, width: 75, align: right"][/TD]
[TD="class: xl65, width: 75, align: right"][/TD]
[TD="class: xl65, width: 75, align: right"][/TD]
[TD="class: xl65, width: 75, align: right"][/TD]

</tbody>

	H	H	H					H	H	H	H

<colgroup><col style="mso-width-source:userset;mso-width-alt:2742; width:56pt" span="12" width="75"> </colgroup><tbody>
[TD="class: xl63, width: 75, align: right"]23/04/2018[/TD]
[TD="class: xl63, width: 75, align: right"] 24/04/2018
[/TD]
[TD="class: xl63, width: 75, align: right"] 25/04/2018
[/TD]
[TD="class: xl63, width: 75, align: right"] 26/04/2018
[/TD]
[TD="class: xl63, width: 75, align: right"]27/04/2018
[/TD]
[TD="class: xl63, width: 75, align: right"]28/04/2018
[/TD]
[TD="class: xl63, width: 75, align: right"]29/04/2018
[/TD]
[TD="class: xl63, width: 75, align: right"] 30/04/2018
[/TD]
[TD="class: xl63, width: 75, align: right"]01/05/2018
[/TD]
[TD="class: xl63, width: 75, align: right"]02/05/2018
[/TD]
[TD="class: xl63, width: 75, align: right"]03/05/2018
[/TD]
[TD="class: xl63, width: 75, align: right"]04/05/2018[/TD]

</tbody>

 

[steve the fish]

Add another condition to the countifs, eg:

=COUNTIFS(C11:Z11,">="&E4,C11:Z11,"<="&F4,C12:Z12,"H")