Formula Help: Count Number of candidates that worked within a month and year

[Magoosball]

I have 2 Excel Tables
Image 1: Lists off each Month and Year
Image 2: Lists off working employees with start and end dates

On Image 1 there is a blank column for "Number Working on Assignment". I'm looking to write a formula here that shows the number of candidates that worked at least 1 day (Inclusive) in the month / year listed on the left of image 1. The employee start and end dates are listed in a separate table and I included in image 2.
Once note ---- the candidate ID column in image 2 isn't unique. a candidate can have multiple start and end dates.

I have Excel 365 and can add any helper columns that are needed... Thank you so much for your help.

 

[JamesCanale]

I'm not sure I understand, but:

Book1
	A	B	C	D	E	F	G	H	I
1	Year	Month	Number working				Candidate ID	Start	End
2	2020	January	3				1	11/1/2019	3/2/2020
3	2020	February	4				1	6/1/2020	1/15/2021
4	2020	March	5				1	6/1/2021	5/1/2022
5	2020	April	4				2	2/1/2020	12/1/2020
6	2020	May	5				2	9/1/2021	12/25/2021
7	2020	June	6				2	9/1/2022	5/3/2023
8	2020	July	5				3	10/1/2019	10/15/2021
9	2020	August	5				3	2/15/2022	6/15/2022
10	2020	September	6				4	5/1/2020	3/1/2021
11	2020	October	6				4	11/30/2021	3/25/2022
12	2020	November	6				4	11/30/2022	3/1/2023
13	2020	December	5				5	12/30/2019	1/13/2022
14	2021	January	5				6	2/29/2020	6/30/2020
15	2021	February	4				6	9/29/2020	5/15/2021
16	2021	March	3				6	9/29/2021	8/29/2022
17	2021	April	3
18	2021	May	3
19	2021	June	3
20	2021	July	3
21	2021	August	3
22	2021	September	5
23	2021	October	5
24	2021	November	4
25	2021	December	5
26	2022	January	4
27	2022	February	4
28	2022	March	4
29	2022	April	3
30	2022	May	2
31	2022	June	2
32	2022	July	1
33	2022	August	1
34	2022	September	1
35	2022	October	1
36	2022	November	1
37	2022	December	2
38	2023	January	2
39	2023	February	2
40	2023	March	1
41	2023	April	1
42	2023	May	1
43	2023	June	0
44	2023	July	0
45	2023	August	0
46	2023	September	0
47	2023	October	0
48	2023	November	0
49	2023	December	0
Sheet1

Cell Formulas
Range	Formula
C2:C49	C2	=LET(d,DATEVALUE(B2:B49&"1, "&A2:A49),a,(EOMONTH(d,0)>TRANSPOSE(H2:H16))*(d<TRANSPOSE(I2:I16)),b,SEQUENCE(COLUMNS(a),1,1,0),MMULT(a,b))
Dynamic array formulas.

 

[Magoosball]

I'm not sure I understand, but:

Book1
	A	B	C	D	E	F	G	H	I
1	Year	Month	Number working				Candidate ID	Start	End
2	2020	January	3				1	11/1/2019	3/2/2020
3	2020	February	4				1	6/1/2020	1/15/2021
4	2020	March	5				1	6/1/2021	5/1/2022
5	2020	April	4				2	2/1/2020	12/1/2020
6	2020	May	5				2	9/1/2021	12/25/2021
7	2020	June	6				2	9/1/2022	5/3/2023
8	2020	July	5				3	10/1/2019	10/15/2021
9	2020	August	5				3	2/15/2022	6/15/2022
10	2020	September	6				4	5/1/2020	3/1/2021
11	2020	October	6				4	11/30/2021	3/25/2022
12	2020	November	6				4	11/30/2022	3/1/2023
13	2020	December	5				5	12/30/2019	1/13/2022
14	2021	January	5				6	2/29/2020	6/30/2020
15	2021	February	4				6	9/29/2020	5/15/2021
16	2021	March	3				6	9/29/2021	8/29/2022
17	2021	April	3
18	2021	May	3
19	2021	June	3
20	2021	July	3
21	2021	August	3
22	2021	September	5
23	2021	October	5
24	2021	November	4
25	2021	December	5
26	2022	January	4
27	2022	February	4
28	2022	March	4
29	2022	April	3
30	2022	May	2
31	2022	June	2
32	2022	July	1
33	2022	August	1
34	2022	September	1
35	2022	October	1
36	2022	November	1
37	2022	December	2
38	2023	January	2
39	2023	February	2
40	2023	March	1
41	2023	April	1
42	2023	May	1
43	2023	June	0
44	2023	July	0
45	2023	August	0
46	2023	September	0
47	2023	October	0
48	2023	November	0
49	2023	December	0
Sheet1

Cell Formulas
Range	Formula
C2:C49	C2	=LET(d,DATEVALUE(B2:B49&"1, "&A2:A49),a,(EOMONTH(d,0)>TRANSPOSE(H2:H16))*(d<TRANSPOSE(I2:I16)),b,SEQUENCE(COLUMNS(a),1,1,0),MMULT(a,b))
Dynamic array formulas.

this is exactly what I was looing for. thank you very much!