T_FREEDAYS

[Xlambda]

T_FREEDAYS optional tool formula for ACALENDAR to easily replace your free days array(holidays) argument (h) for the entire year, if you want to show icons for Sundays, or, Sundays and Saturdays, or Fridays, etc., can be embedded in ACALENDAR. Calls AFLATTEN and APPEND2V (proves that APPEND2V works inside other formulas, handling array calculations)

=LAMBDA(y,fwd,add,excl,
    LET(fd,EDATE("1-1-"&y,0),
       fdwd,WEEKDAY(fd,3),s,SEQUENCE(54,7,fd-fdwd),xw,ISNUMBER(XMATCH(SEQUENCE(,7),fwd)),fs,FILTER(s,xw),
       ca,YEAR(fs)=YEAR(fd),cb,NOT(ISNUMBER(XMATCH(fs,excl))),ffs,IF(ca*cb,fs,""),x,AFLATTEN(ffs),xx,FILTER(x,x<>""),
       APPEND2V(add,xx,)
    )
)

LAMBDA 5.0.xlsm
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R
1	formula to build easy your free days for the whole year,if you want to show for ex. Sundays or, Sundays and Saturdays, Fridays..etc.
2
3	year	21
4	add to the regular free dates				free days can be defined and call as a name using the formula or embeded directly in the ACALENDAR formula
5	01-01-21				=T_FREEDAYS(21,7,A5:A12,A17:A19)
6	31-12-21				01-01-21
7	04-07-21				31-12-21		=ACALENDAR(,"mar",21,T_FREEDAYS(21,7,A5:A12,A17:A19),P11:P16)
8	17-03-21				04-07-21				Mar	2021
9	08-03-21				17-03-21		Mon	Tue	Wed	Thu	Fri	Sat	Sun			other dates
10	05-03-21				08-03-21		01	02	03 ?	04	05 ⛱	06	07			used in ACALENDAR
11	05-07-21				05-03-21		08 ⛱	09	10	11	12	13	14 ⛱			03-03-21
12	28-07-21				05-07-21		15	16	17 ⛱	18	19 ?	20	21			23-03-21
13					28-07-21		22	23 ?	24	25	26	27	28 ⛱			31-03-21
14					03-01-21		29	30	31 ?							02-07-21
15	exclude from regular				10-01-21											14-07-21
16	free dates				17-01-21											18-07-21
17	07-03-21				24-01-21
18	21-03-21				31-01-21		on July will see this calendar
19	18-07-21				07-02-21		=ACALENDAR(,"jul",21,T_FREEDAYS(21,7,A5:A12,A17:A19),P11:P16)
20					14-02-21				Jul	2021
21	all free days easier to check				21-02-21		Mon	Tue	Wed	Thu	Fri	Sat	Sun
22	=AUNSTACK(E6#,19)				28-02-21					01	02 ?	03	04 ⛱
23	01-01-21	04-04-21	22-08-21		14-03-21		05 ⛱	06	07	08	09	10	11 ⛱
24	31-12-21	11-04-21	29-08-21		28-03-21		12	13	14 ?	15	16	17	18 ?
25	04-07-21	18-04-21	05-09-21		04-04-21		19 ?	20	21	22	23	24	25 ⛱
26	17-03-21	25-04-21	12-09-21		11-04-21		26	27	28 ⛱	29	30	31
27	08-03-21	02-05-21	19-09-21		18-04-21
28	05-03-21	09-05-21	26-09-21		25-04-21
29	05-07-21	16-05-21	03-10-21		02-05-21		Obs. Remember!! to leave the ACALENDAR updating itself
30	28-07-21	23-05-21	10-10-21		09-05-21		we ignore all the arguments for d,m,y ACALENDAR(,,,h,o)
31	03-01-21	30-05-21	17-10-21		16-05-21
32	10-01-21	06-06-21	24-10-21		23-05-21
33	17-01-21	13-06-21	31-10-21		30-05-21
34	24-01-21	20-06-21	07-11-21		06-06-21
35	31-01-21	27-06-21	14-11-21		13-06-21
36	07-02-21	04-07-21	21-11-21		20-06-21
37	14-02-21	11-07-21	28-11-21		27-06-21
38	21-02-21	25-07-21	05-12-21		04-07-21
39	28-02-21	01-08-21	12-12-21		11-07-21
40	14-03-21	08-08-21	19-12-21		25-07-21
41	28-03-21	15-08-21	26-12-21		01-08-21	cutted here on purpose , for not increasing the size of the minisheet
42					08-08-21	allvalues are grouped under AUNSTACK formula
ACALENDAR plus

Cell Formulas
Range	Formula
E5,A22,G19,G7	E5	=FORMULATEXT(E6)
E6:E62	E6	=T_FREEDAYS(21,7,A5:A12,A17:A19)
G8:M15	G8	=ACALENDAR(,"mar",21,T_FREEDAYS(21,7,A5:A12,A17:A19),P11:P16)
G20:M27	G20	=ACALENDAR(,"jul",21,T_FREEDAYS(21,7,A5:A12,A17:A19),P11:P16)
A23:C41	A23	=AUNSTACK(E6#,19)
Dynamic array formulas.

 

[Xlambda]

cool icons...

LAMBDA 5.0.xlsm
	A	B	C	D	E	F	G	H	I	J	K	L	M
1	for fun here are other cool ACALENDAR icons, added by holding Win key and pressing . Key.
2	???☠⛷??✨⛳????⏰⛵?????⭐??❌⭕?❗‼⁉?☢☣⚠❎✅??⏸⏹⏺☑✔➕➖✖???⚫⚪⬛⬜◼◻◾◽▪▫???????????♥♦?☎???????????⏳✈?⚓??‍????‍☠️??♨???⛱
3
4	extracting them separate with use of MID, to get their UNICODE values does not work as expected												cutted
5	=MID(A2,SEQUENCE(LEN(A2)),1)
6	�
7	�		adding "," between each characters and extract them with ASPLIT will do the trick
8	�		?,?,?,☠,⛷,?,?,✨,⛳,?,?,?,?,⏰,⛵,?,?,?,?,?,⭐,?,?,❌,⭕,?,❗,‼,⁉,?,☢,☣,⚠,❎,✅,?,?,⏸,⏹,⏺,☑,✔,➕,➖,✖,?,?,?,⚫,⚪,⬛,⬜,◼,◻,◾,◽,▪,▫,?,?,?,?,?,?,?,?,?,?,?,♥,♦,?,☎,?,?,?,?,?,?,?,?,?,?,?,⏳,✈,?,⚓,?,?‍?,?,?,?‍☠️,?,?,♨,?,?,?,⛱
9	�
10	�		=ASPLIT(C8,",")		ASPLIT
11	�		?	?	?	☠	⛷	?	?	✨	⛳	?	?
12	☠
13	⛷		stack them
14	�		=ASTACK(C11#,10)		ASTACK
15	�		?	?	?	☠	⛷	?	?	✨	⛳	?
16	�		?	?	?	⏰	⛵	?	?	?	?	?
17	�		⭐	?	?	❌	⭕	?	❗	‼	⁉	?
18	✨		☢	☣	⚠	❎	✅	?	?	⏸	⏹	⏺
19	⛳		☑	✔	➕	➖	✖	?	?	?	⚫	⚪
20	�		⬛	⬜	◼	◻	◾	◽	▪	▫	?	?
21	�		?	?	?	?	?	?	?	?	?	♥
22	�		♦	?	☎	?	?	?	?	?	?	?
23	�		?	?	?	?	⏳	✈	?	⚓	?	?‍?
24	�		?	?	?‍☠️	?	?	♨	?	?	?	⛱
25	�
26	�
27	�		map UNICODE val to be used inside UNICHAR(), (inside ACALENDAR lambda,after LET (variables td, for day,hy for free days,ot for other dates)
28	⏰		easy to edit in name manager =LAMBDA(d,m,y,h,o,LET(td,UNICHAR(128197),hy,UNICHAR(9969),ot,UNICHAR(128681),yx,…......
29	⛵		=IFERROR(C15#&" - "&UNICODE(C15#),"")
30	�		? - 128197	? - 128512	? - 128547	☠ - 9760	⛷ - 9975	? - 128077	? - 128078	✨ - 10024	⛳ - 9971	? - 128272
31	�		? - 128187	? - 128198	? - 128467	⏰ - 9200	⛵ - 9973	? - 128674	? - 127957	? - 127958	? - 127965	? - 127774
32	�		⭐ - 11088	? - 127775	? - 128219	❌ - 10060	⭕ - 11093	? - 128683	❗ - 10071	‼ - 8252	⁉ - 8265	? - 128261
33	�		☢ - 9762	☣ - 9763	⚠ - 9888	❎ - 10062	✅ - 9989	? - 128160	? - 127379	⏸ - 9208	⏹ - 9209	⏺ - 9210
34	�		☑ - 9745	✔ - 10004	➕ - 10133	➖ - 10134	✖ - 10006	? - 128280	? - 128308	? - 128309	⚫ - 9899	⚪ - 9898
35	�		⬛ - 11035	⬜ - 11036	◼ - 9724	◻ - 9723	◾ - 9726	◽ - 9725	▪ - 9642	▫ - 9643	? - 128310	? - 128312
36	�		? - 128311	? - 128313	? - 128314	? - 128315	? - 128306	? - 128307	? - 128722	? - 129351	? - 127942	♥ - 9829
37	�		♦ - 9830	? - 128273	☎ - 9742	? - 128222	? - 128190	? - 128269	? - 128270	? - 128161	? - 128176	? - 128228
38	�		? - 128229	? - 128233	? - 128203	? - 128206	⏳ - 9203	✈ - 9992	? - 128752	⚓ - 9875	? - 127937	?‍? - 127987
39	�		? - 127987	? - 127988	?‍☠️ - 127988	? - 128681	? - 129517	♨ - 9832	? - 128718	? - 129527	? - 127777	⛱ - 9969
40	⭐	cutted
ACALENDAR icons

Cell Formulas
Range	Formula
A5,C29,C14,C10	A5	=FORMULATEXT(A6)
A6:A168	A6	=MID(A2,SEQUENCE(LEN(A2)),1)
C11:CX11	C11	=ASPLIT(C8,",")
C15:L24	C15	=ASTACK(C11#,10)
C30:L39	C30	=IFERROR(C15#&" - "&UNICODE(C15#),"")
Dynamic array formulas.