How can I add multiple events to the calendar in Excel without overlapping?

[unalivedpingu]

so I have a calendar made in Excel with 3 cells under each date which is where I want the events to populate, however I don't really know the exact formula to do that. Currently I have a table with the events and I'm using the following formula to highlight the dates the events fall on:

IF(B4="",FALSE,SUMPRODUCT((B4>=INDIRECT("Table7[Start]"))*(B4<=INDIRECT("Table7[End]"))))

Where B4 is the starting date of the calendar, Table7 is the table of events, Start is the start date of the event and End is the end date of the events.

calendar.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y	Z	AA	AB	AC	AD	AE	AF	AG	AH	AI	AJ
1
2
3
4		JULY								AUGUST								SEPTEMBER										Event	Colour			Events
5																												1				No	Event	Description	Start	End
6		M	T	W	T	F	S	S		M	T	W	T	F	S	S		M	T	W	T	F	S	S				2				3			2-Aug-2021	#################
7					1	2	3	4								1				1	2	3	4	5				3				4			9-Aug-2021	#################
8																												4				5			6-Sep-2021	#################
9																												5				6			##################	#################
10																																7			4-Oct-2021	8-Oct-2021
11		5	6	7	8	9	10	11		2	3	4	5	6	7	8		6	7	8	9	10	11	12								8			##################	#################
12																																9			8-Nov-2021	#################
13																																10			##################	#################
14																																11			6-Dec-2021	#################
15		12	13	14	15	16	17	18		9	10	11	12	13	14	15		13	14	15	16	17	18	19								12			##################	#################
16																																13			3-Jan-2022	7-Jan-2022
17																																14			##################	#################
18																																15			7-Feb-2022	#################
19		19	20	21	22	23	24	25		16	17	18	19	20	21	22		20	21	22	23	24	25	26								16			##################	#################
20																																17			7-Mar-2022	#################
21																																18			##################	#################
22
23		26	27	28	29	30	31			23	24	25	26	27	28	29		27	28	29	30											No	Event	Description	Start	End
24																																11			##################	#################
25																																12			##################	1-Oct-2021
26																																13			8-Nov-2021	#################
27										30	31																					14			6-Dec-2021	#################
28
29																																No	Event	Description	Start	End
30																																15			##################	#################
31																																16			8-Nov-2021	#################
32
33		OCTOBER								NOVEMBER								DECEMBER														No	Event	Description	Start	End
34																																17			##################	#################
35		M	T	W	T	F	S	S		M	T	W	T	F	S	S		M	T	W	T	F	S	S								18			##################	#################
36						1	2	3		1	2	3	4	5	6	7				1	2	3	4	5
37																																No	Event	Description	Start	End
38																																19			6-Sep-2021	#################
39																																20			4-Oct-2021	8-Oct-2021
40		4	5	6	7	8	9	10		8	9	10	11	12	13	14		6	7	8	9	10	11	12								21			1-Nov-2021	#################
41
42
43
44		11	12	13	14	15	16	17		15	16	17	18	19	20	21		13	14	15	16	17	18	19
45
46
47
48		18	19	20	21	22	23	24		22	23	24	25	26	27	28		20	21	22	23	24	25	26
49
50
51
52		25	26	27	28	29	30	31		29	30							27	28	29	30	31
53
54
55
56
57
58
59
Training Calendar

Cell Formulas
Range	Formula
AI6:AJ6,AI34:AJ35	AI6	=Events!B9
AI7:AJ7	AI7	=Events!D9
AI8:AJ8	AI8	=Events!B10
AI9:AJ9	AI9	=Events!D10
AI10:AJ10	AI10	=Events!B11
AI11:AJ11	AI11	=Events!D11
AI12:AJ12	AI12	=Events!B12
AI13:AJ13	AI13	=Events!D12
AI14:AJ14,AI30:AJ31	AI14	=Events!B13
AI15:AJ15	AI15	=Events!D13
AI16:AJ16	AI16	=Events!B14
AI17:AJ17	AI17	=Events!D14
AI18:AJ18,AI24:AJ24	AI18	=Events!B15
AI19:AJ19,AI25:AJ25	AI19	=Events!D15
AI20:AJ20,AI26:AJ26	AI20	=Events!B16
AI21:AJ21,AI27:AJ27	AI21	=Events!D16
F7:H7,S52:V52,K52,C52:H52,S48:X48,K48:P48,C48:H48,S44:X44,K44:P44,C44:H44,S40:X40,K40:P40,C40:H40,K27,S23:U23,K23:P23,C23:G23,S19:X19,K19:P19,C19:H19,S15:X15,K15:P15,C15:H15,S11:X11,K11:P11,C11:H11	F7	=E7+1
B11,R52,J52,B52,R48,J48,B48,R44,J44,B44,R40,J40,B40,J27,R23,J23,B23,R19,J19,B19,R15,J15,B15,R11,J11	B11	=H7+1
AI38:AJ40	AI38	=Events!C44

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
B6:X32,B4,I5,I4:J4,Q5,Q4:R4,B35:X90,B33,I34,I33:J33,Q34,Q33:R33	Expression	=IF(B4="",FALSE,SUMPRODUCT((B4>=INDIRECT("Table7[Start]"))*(B4<=INDIRECT("Table7[End]"))))	text	NO
B6:X32,B4,I5,I4:J4,Q5,Q4:R4,B35:X90,B33,I34,I33:J33,Q34,Q33:R33	Expression	=IF(B4="",FALSE,SUMPRODUCT((B4>=INDIRECT("Table6[Start]"))*(B4<=INDIRECT("Table6[End]"))))	text	NO
B6:X32,B4,I5,I4:J4,Q5,Q4:R4,B35:X90,B33,I34,I33:J33,Q34,Q33:R33	Expression	=IF(B4="",FALSE,SUMPRODUCT((B4>=INDIRECT("Table5[Start]"))*(B4<=INDIRECT("Table5[End]"))))	text	NO
B6:X32,B4,I5,I4:J4,Q5,Q4:R4,B35:X90,B33,I34,I33:J33,Q34,Q33:R33	Expression	=IF(B4="",FALSE,SUMPRODUCT((B4>=INDIRECT("Table4[Start]"))*(B4<=INDIRECT("Table4[End]"))))	text	NO
B6:X32,B4,I5,I4:J4,Q5,Q4:R4,B35:X90,B33,I34,I33:J33,Q34,Q33:R33	Expression	=IF(B4="",FALSE,SUMPRODUCT((B4>=INDIRECT("Table3[Start]"))*(B4<=INDIRECT("Table3[End]"))))	text	NO