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>
</tbody>

23/04/2018	24/04/2018	25/04/2018	26/04/2018	27/04/2018	28/04/2018	29/04/2018	30/04/2018	01/05/2018	02/05/2018	03/05/2018	04/05/2018
	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>
</tbody>

 

[steve the fish]

Add another condition to the countifs, eg:

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