Counting Saturdays & Sundays for specific staff members given a wide range of dates

[pransford]

I work for a event venue. I assign staff members events and I want to count the number of events each one has, and then I want to calculate the how many weekends they might have to work during the same given time frame. I have attached a crude spreadsheet I have started and tried working on, but I am getting lost and going down the rabbit hole, I'm falling behind on my other work.
I hope I did this right...

Event Manager event load worksheet.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P
1	Events	Event Dates		# Halls	Dome	Event Manager	Back up
2	General Assembly of God	1/5/2021	1/10/2021	6	y	Elizabeth
3	Capitol Sports	2/3/2021	2/16/2021	6	y	Sarah			Event Manager	# events	Weekends
4	Haunt Show	3/1/2021	3/8/2021	5		Elizabeth			McKinna	5	52
5	American Bridge League	3/19/2021	3/21/2021	0		Alex			Michael	4
6	Capitol Sports MEQ	3/23/2021	3/29/2021	6	y	Sarah			Emily	3
7	Dot Foods	4/5/2021	4/9/2021	3		Elizabeth			Elizabeth	5
8	NAYDO	4/13/2021	4/17/2021	1		Sarah			Sarah	9
9	Legal Shield	4/13/2021	4/18/2021	4	y	McKinna			Alex	5
10	DSCOOP	4/14/2021	4/24/2021	2		Michael
11	Population Association of America	5/3/2021	6/5/2021	5		Alex
12	Inland Marine Expo	5/22/2021	5/2/2021	2		Sarah
13	COGIC Women	5/27/2021	6/5/2021	5		McKinna
14	Wizard World	6/9/2021	6/13/2021	2	y	Michael
15	Presbyterian Church General Assembly	6/28/2021	7/2/2021	2		Sarah
16	Beachbody	7/5/2021	7/20/2021	6	y	McKinna
17	Younique	7/24/2021	8/1/2021	6	y	Emily
18	Presbyterian Women	8/4/2021	8/8/2021	0		Sarah
19	American Public Works	8/25/2021	9/1/2021	5		Sarah
20	2021 GEAR	9/8/2021	9/18/2021	6	y	Elizabeth
21	TAPPI	9/25/2021	9/30/2021	2		Alex
22	LTD Summit	9/29/2021	10/3/2021	1	y	Emily
23	Stifel	10/3/2021	10/9/2021	3		Elizabeth
24	Sweet Adeline's	#########	#########	3		Michael
25	Jucie+	#########	#########	5		Sarah
26	Bands of America	#########	#########	1	y	Emily
27	SMRP	#########	#########	1		Alex
28	SuperComputing 2021	11/8/2021	#########	6	y	McKinna
29	Gateway Dirt Nationals	#########	12/6/2021	6	y	Michael
30	Intervarsity URBANA 2021	#########	1/4/2022	6	y	McKinna
31	Monster Jam			2	y	McKinna
32	Auto Show			6	y	Sarah
33	RV Show			4		Alex
34	Home Show			4		Emily
Event Manager Work Load Data

Cell Formulas
Range	Formula
K4	K4	=SUMPRODUCT(--(WEEKDAY(ROW(INDIRECT(B2&":"&C30)))=T24))
J4:J9	J4	=COUNTIFS($F$2:$F$34,I4)

 

[Tetra201]

Try creating a (hidden) helper column (say, column X) and populating it starting from cell X2 with the following formula:

=IF(COUNT(B2,C2)=2,NETWORKDAYS.INTL(B2,C2,"1111100"),0)

Then, you can count weekends like this:

=SUMIFS($X$2:$X$34,$F$2:$F$34,I4)

 

[pransford]

Thank you. I will try that.