Repeat a date multiple times spilling over to the adjacent columns

[ShAzeem]

Hi everyone,
A seemingly simple ask I believe for which I even tried ChatGPT and couldn't get it to solve this issue.
I have a date in Cell A1. In Cell A2, a formula is required which would return the date in Cell A1 and spill it over 5 times to the right as below:

	A	B	C	D	E	F
1	Mar'24
2	Mar'24	Mar'24	Mar'24	Mar'24	Mar'24	Mar'24

Thanks and very much appreciated.

Regards,
Azeem

 

[Fluff]

How about

Fluff.xlsm
	A	B	C	D	E
1	21/07/2024
2	21/07/2024	21/07/2024	21/07/2024	21/07/2024	21/07/2024
Sheet6

Cell Formulas
Range	Formula
A2:E2	A2	=SEQUENCE(,5,A1,0)
Dynamic array formulas.

 

[ShAzeem]

Ah .... Thanks. Perfect..

 

[Fluff]

You're welcome & thanks for the feedback.

 

[ShAzeem]

How can we do the same for a text instead of a date or value?

 

[Fluff]

How about

=EXPAND(A1,,5,A1)