Google Sheet Date Range Lookup Formula

[ryansm05]

Hi,

I am looking for a formula that looks between two date ranges (that can be adjusted in cell B10 and B11 of the below) and return the COUNT of data within those ranges.

If anyone can help with this it'd be much appreciated.

Link to the Google Sheet here: Google Sheets: Sign-in

Thanks
Ryan

 

[maiarib]

Hi,
You can use the filter formula.

Google sheet link here:

Copy of Formula Help

Sheet1 2022-09-03,2022-09-04,2022-09-10,2022-09-11,2022-09-12,2022-09-16,2022-09-17,2022-09-18,2022-10-01,2022-10-02,2022-10-03,2022-10-08,2022-10-09,2022-10-10,2022-10-14,2022-10-15,2022-10-16 Team 1,BRE(A),TOT(H),LIV(H),LEE(A) Team 2,SOU(H),LEE(A),NOT(A),CHE(H) Team 3,CRY(H),LIV(A),TOT(H),BRE(A)

docs.google.com

If you need more help, please say.

 

[Fluff]

@maiarib Please post your solution to the board as per Rule#4 Thanks

 

[Fluff]

How about

=COUNTIFS(C4:S4,">="&B10,C4:S4,"<="&B11)