Setting up Observed Holidays on a Dynamic Calendar based upon the year

[life_in_picture_format]

Ok, I am very sorry but I cannot get the XL2BB tool to work for me these days. Excel keeps blocking it and after a few tries following the "how-to" I've decided to post a screenshot with my question.
I am trying to make my mom this calendar/vacation accrual calculator worksheet. If someone uses 8 hours of VAC or whatever other types of "Leave" sh will input the number of hours on this sheet under the correct month/date and I've set up the formulas to add the accruals and subtract the time used (that's the easy part). Here is a screenshot:

This is set to adjust the dates based upon the year which she types up in the year cell in the left corner.

Formula for the days to adjust are in the rows of dates, for example, Feb (row 42) the first Monday is a blank cell here is the formula: =IF(WEEKDAY(A42,1)=$I$4, A42,"")
For the following day Feb 1st under Tuesday formula is: =IF(B42="",IF(WEEKDAY(A42,1)=MOD($I$4,7)+1,A42,""),B42+1)
I there a way to maybe use conditional formatting to highlight the Holidays for the year based upon that specific year. See here if a holiday lands on a Sunday we observe it on that following Monday or if a holiday falls on a Saturday it is observed on Friday before. They are paid holiday pay so she would like to track that but I am not sure how to set that up for her.
Wanted to bring this one to you all to see what you think.
IF you need more info let me know and I will try to post the XL2BBB

 

[life_in_picture_format]

You are so nice! thank you VERY much

I noticed that the vertical gray bars denoting weekends do not shift correctly when, for example, you change the start-of-week option in I4 from Monday to Sunday. Here is an idea using conditional formatting that determines whether a number is in row 10 and an "S" is in row 9. If so, then the cells are shaded and the font colors adjusted as necessary. Before implementing this, you will want to select B10:B21 and click on the "paint brush" Format Painter and then swipe across your entire range or C:AL. Then apply the conditional formatting rules to handle the row heading formats, and vertical bar formats for weekends and holidays.

MrExcel_20220503.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	AK	AL
1	Accruals
2
3	Year		Month						Start Day
4	2021		2						1			1: Sunday, 2: Monday
5																					Vacation								Personal Holiday
6			NAME:												EE:						Accrual Level:				7				Accrual Level:				C
7	2021-2022
8																																					[42]
9		S	M	T	W	T	F	S	S	M	T	W	T	F	S	S	M	T	W	T	F	S	S	M	T	W	T	F	S	S	M	T	W	T	F	S	S	M
10	Feb-2021		1	2	3	4	5	6	7	8	9	10	11	12	13	14	15	16	17	18	19	20	21	22	23	24	25	26	27	28
11	Personal Holiday								1
12	Vacation
13	Sick Leave
14	Family Sick Leave																							2
15	Admin Leave																							4
16	Bereavement
17	Vacation in Lieu of Sick
18	FMLA
19	PDL
20	OPT
21	OVT
YearlyCalendar

Cell Formulas
Range	Formula
A7	A7	=IF($C$4=1,A4,A4&"-"&A4+1)
B9	B9	=CHOOSE(1+MOD($I$4+1-2,7),"S","M","T","W","T","F","S")
C9	C9	=CHOOSE(1+MOD($I$4+2-2,7),"S","M","T","W","T","F","S")
D9	D9	=CHOOSE(1+MOD($I$4+3-2,7),"S","M","T","W","T","F","S")
E9	E9	=CHOOSE(1+MOD($I$4+4-2,7),"S","M","T","W","T","F","S")
F9	F9	=CHOOSE(1+MOD($I$4+5-2,7),"S","M","T","W","T","F","S")
G9	G9	=CHOOSE(1+MOD($I$4+6-2,7),"S","M","T","W","T","F","S")
H9	H9	=CHOOSE(1+MOD($I$4+7-2,7),"S","M","T","W","T","F","S")
I9:AL9	I9	=B9
A10	A10	=DATE($A$4,$C$4,1)
B10	B10	=IF(WEEKDAY(A10,1)=$I$4,A10,"")
C10	C10	=IF(B10="",IF(WEEKDAY(A10,1)=MOD($I$4,7)+1,A10,""),B10+1)
D10	D10	=IF(C10="",IF(WEEKDAY(A10,1)=MOD($I$4+1,7)+1,A10,""),C10+1)
E10	E10	=IF(D10="",IF(WEEKDAY(A10,1)=MOD($I$4+2,7)+1,A10,""),D10+1)
F10	F10	=IF(E10="",IF(WEEKDAY(A10,1)=MOD($I$4+3,7)+1,A10,""),E10+1)
G10	G10	=IF(F10="",IF(WEEKDAY(A10,1)=MOD($I$4+4,7)+1,A10,""),F10+1)
H10	H10	=IF(G10="",IF(WEEKDAY(A10,1)=MOD($I$4+5,7)+1,A10,""),G10+1)
I10:AL10	I10	=IF(H10="","",IF(MONTH(H10+1)<>MONTH(H10),"",H10+1))

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
B10:AL10	Expression	=AND(ISNUMBER(B$10),B$9="S")	text	NO
B11:AL21	Expression	=AND(ISNUMBER(B$10),B$9="S")	text	NO
B10:AL21	Expression	=ISNUMBER(MATCH(DATE(YEAR($A$10),MONTH($A$10),DAY(B$10)),Holidays!$C$3:$C$10,0))	text	NO
B10:AL10	Expression	=ISNUMBER(B$10)	text	NO

For reference, the dark gray is color hex code: #595959 and white font
light gray is: #D9D9D9 and black font
yellow is standard: #FFFF00 and black font
light blue is: #D3EBF3 and black font

 

[KRice]

I'm happy to help.