Beginner User: How to get this done?

[smirkin_monkey]

I have the following data

I want to analyze the data and answer the following questions in the same format

How to do this?

Since I'm a super-beginner at Excel, I'm struggling to this data analysis. Requesting the community's help.

 

[kweaver]

Welcome. Please install XL2BB to show your sample data so that someone trying to help you doesn't have to reenter data to illustrate a solution.

 

[kweaver]

Using partial data, how about this? Workable?

062023 Misc.xlsm
	C	D	E	F	G	H	I	J
1	Tier							# weeks (FYI)
2	Tier 1	1/1/2023	1/17/2023			<4	4	2.285714286
3	Tier 1	1/3/2022	1/28/2022			4-8	1	3.571428571
4	Tier 3					>8	1	0
5	Tier 2							0
6	Tier 3							0
7	Tier 1	7/13/2022	10/21/2022					14.28571429
8	Tier 1	6/15/2023	7/31/2023					6.571428571
9	Tier 1	1/1/2023	1/15/2023					2
10	Tier 3							0
11	Tier 2							0
12	Tier 3							0
13	Tier 1	4/9/2023	4/19/2023					1.428571429
Sheet24

Cell Formulas
Range	Formula
I2	I2	=SUMPRODUCT((4>DATEDIF($D$2:$D$13,$E$2:$E$13,"D")/7)*("Tier 1"=$C$2:$C$13))
I3	I3	=SUMPRODUCT((4<=DATEDIF($D$2:$D$13,$E$2:$E$13,"D")/7)*(8>=DATEDIF($D$2:$D$13,$E$2:$E$13,"D")/7)*("Tier 1"=$C$2:$C$13))
I4	I4	=SUMPRODUCT((8<DATEDIF($D$2:$D$13,$E$2:$E$13,"D")/7)*("Tier 1"=$C$2:$C$13))
J2:J13	J2	=DATEDIF(D2,E2,"d")/7