How many weeks fall within the program dates

[cjlittlet]

I need help finding a formula or set of formulas that will tell me what I need to know.

I have to take a date range and then calculate how many weeks under each program a person qualified for based on the number of Saturdays.

program dates:
program 1: 04.04.20 - 07.25.20
program 2: 08.01.20 - 09.12.20
program 3: 01.02.21 - 03.13.21
program 4: 03.20.21 - 06.26.21

For example:
if a person was active from 04.13.20 to 02.15.21 then it would say something like
Program1: 15
Program2: 7
Program3: 7
Program4: 0

wb example.xlsm
	A	B	C	D	E	F	G	H	I	J
1	FIRST NAME	LAST NAME	ID#	Wk Start	Wk Stop	Prg1	Prg2	Prg3	Prg4	Date Entered
2				06.13.20	06.13.20	1				05.23.22
3				06.13.20	06.20.20	2				05.31.22
4				06.06.20	06.06.20	1				05.23.22
5				02.06.21	02.20.21			3		05.23.22
6				06.06.20	09.05.20	7	6			05.23.22
Sheet1

 

[Eric W]

How about:

Book1
	A	B	C	D	E	F	G	H	I	J	K	L	M	N
1	First Name	Last Name	ID#	Start	Stop	Prg1	Prg2	Prg3	Prg4			Program	Start	Stop
2	John	Doe	1	4/13/2020	2/26/2021	15	7	8	0			Prg1	4/4/2020	7/25/2020
3												Prg2	8/1/2020	9/12/2020
4												Prg3	1/2/2021	3/13/2021
5												Prg4	3/20/2021	6/26/2021
Sheet11

Cell Formulas
Range	Formula
F2:I2	F2	=LET(s,MAX($D2,VLOOKUP(F$1,$L$2:$N$5,2,0)),e,MIN($E2,VLOOKUP(F$1,$L$2:$N$5,3,0)),IF(e-s>0,NETWORKDAYS.INTL(s,e,"1111101"),0))

 

[cjlittlet]

How about:

Book1
	A	B	C	D	E	F	G	H	I	J	K	L	M	N
1	First Name	Last Name	ID#	Start	Stop	Prg1	Prg2	Prg3	Prg4			Program	Start	Stop
2	John	Doe	1	4/13/2020	2/26/2021	15	7	8	0			Prg1	4/4/2020	7/25/2020
3												Prg2	8/1/2020	9/12/2020
4												Prg3	1/2/2021	3/13/2021
5												Prg4	3/20/2021	6/26/2021
Sheet11

Cell Formulas
Range	Formula
F2:I2	F2	=LET(s,MAX($D2,VLOOKUP(F$1,$L$2:$N$5,2,0)),e,MIN($E2,VLOOKUP(F$1,$L$2:$N$5,3,0)),IF(e-s>0,NETWORKDAYS.INTL(s,e,"1111101"),0))

Hi Eric, this is perfect! I added an equal sign to the if(e-s>=0.... so it would give me single weeks as well. Thank you so much for the quick response.

 

[Eric W]

Glad it works for you! Thanks for the feedback.

 

[cjlittlet]

@Eric W I posted another request similar to this one. Would you mind terribly taking a look? I'm not sure if I explained what I'm looking for very well.