Countif or Sumifs help needed

[Wimpie]

Good day

Please note that I have a Sheet called "Daily"
In this sheet I have the following:
Column C is in [HH]:mm

A	B	C
Date	Day	Hrs Driven
2016/09/23	Friday
2016/09/24	Saturday
2016/09/25	Sunday
2016/09/26	Monday
2016/09/27	Tuesday
2016/09/28	Wednesday
2016/09/29	Thursday
2016/09/30	Friday
2016/10/01	Saturday	03:53
2016/10/02	Sunday	02:49
2016/10/03	Monday	04:01
2016/10/04	Tuesday	04:38
2016/10/05	Wednesday	01:48

<tbody>
</tbody>

In a Sheet called "Cycle" I have the following:
I need Column F of the "Cycle" sheet to count the Saturdays in the "Daily" Sheet if there is hours in Column C, between the dates in Column B and C in the "Cycle" sheet.

B	C	F
Date From	Date to	Saturdays Worked Count
2016/09/19	2016/10/16
2016/10/17	2016/1113

<tbody>
</tbody>

 

[AliGW]

This should get you started:

Excel 2016 (Windows) 32 bit
	A	B	C	D	E	F	G	H
1	A	B	C			B	C	F
2	Date	Day	Hrs Driven			Date From	Date to	Saturdays Worked Count
3	23/09/2016	Friday				19/09/2016	16/10/2016	1
4	24/09/2016	Saturday				17/10/2016	13/11/2016	0
5	25/09/2016	Sunday
6	26/09/2016	Monday
7	27/09/2016	Tuesday
8	28/09/2016	Wednesday
9	29/09/2016	Thursday
10	30/09/2016	Friday
11	01/10/2016	Saturday	03:53
12	02/10/2016	Sunday	02:49
13	03/10/2016	Monday	04:01
14	04/10/2016	Tuesday	04:38
15	05/10/2016	Wednesday	01:48
Sheet1

Cell Formulas
Range	Formula
H3	=COUNTIFS($B$3:$B$15,"Saturday",$C$3:$C$15,"<>",$A$3:$A$15,">="&F3,$A$3:$A$15,"<="&G3)

 

[Wimpie]

Hi AliGW

Forgot to mention that Column C in the daily file has the below formula
=IF(SUMIF(Data!D:D,A2,Data!O:O)=0,"",(SUMIF(Data!D:D,A2,Data!O:O)))
This is causing your formula to count all the Saturdays

 

[Wimpie]

Hi
I changed the "<>" in your formula to ">0" and that worked perfectly.
Thank you so much

 

[AliGW]

Not too hard to overcome:

=COUNTIFS($B$3:$B$15,"Saturday",$C$3:$C$15,">0",$A$3:$A$15,">="&F3,$A$3:$A$15,"<="&G3)

 

[Wimpie]

Thank you so much for the help
This worked great

 

[AliGW]

You're welcome!