How to add Columns in a dynamic range?

[Lacan]

Hello Guys,

Would like to add Columns (with days of week) in a dynamic range.
Can you please help?
Example below.
Thank you very much.

Fórmula Principal para o Ficheiro VDF.xlsm
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R
1
2			ORIGINAL
3			10-fev	11-fev	12-fev	13-fev	14-fev	15-fev	16-fev
4
5			END RESULTS
6			10-fev	SEG	11-fev	TER	12-fev	QUA	13-fev	QUI	14-fev	SEX	15-fev	SÁB	16-fev	DOM
7
8
9
10
11
12
Folha14

Cell Formulas
Range	Formula
C3:I3	C3	=TRANSPOSE(SEQUENCE(7,,TODAY()-WEEKDAY(TODAY(),2)+1))
D6,P6,N6,L6,J6,H6,F6	D6	=UPPER(TEXT(C6,"ddd"))
Dynamic array formulas.

 

[Fluff]

How about

=LET(a,TOCOL(C3#),TOROW(HSTACK(a,TEXT(a,"ddd"))))

 

[Fluff]

Another option without using C3#

=LET(a,SEQUENCE(7,,WORKDAY.INTL(TODAY()+1,-1,"0111111")),TOROW(HSTACK(a,TEXT(a,"ddd"))))

 

[Lacan]

Dear @Fluff

Works very well!
Thank you very much!

 

[Fluff]

You're welcome & thanks for the feedback.