Keeping date format while using in a sequence formula

[PuntingJawa]

I'm trying to keep a date format while using a sequence formula.
A2 has the date as M/DD/YYYY
A6 is the line count
F2 is where this primary formula will be. "=A2&TEXT(SEQUENCE(A6),"")" is the formula I am currently using for my usual sequencing of specific information from other cells. In this case I figured using "=A2&TEXT(SEQUENCE(A6),"dd-mmm-yyyy")" would work, and it does in a way, as far as a partial format.
Example below: Under B2 is where my formula should go. A6 is the line count for the sequence part of the formula. A2 where the date should come from. I would like it to pull the current format in A2 and change it to "DD-MMM-YYYY".

Book1
	A	B
1	Date	Manufacturing:
2	6/20/2023	4509701-Jan-1900
3	Start #	4509702-Jan-1900
4	3	4509703-Jan-1900
5	Count	4509704-Jan-1900
6	50	4509705-Jan-1900
Sheet1

Cell Formulas
Range	Formula
B2:B51	B2	=A2&TEXT(SEQUENCE(A6),"dd-mmm-yyyy")
Dynamic array formulas.

 

[Fluff]

If A2 is an actual date & not text, try

=A2+SEQUENCE(A6)

and format the column to show the date as you want.

 

[PuntingJawa]

If A2 is an actual date & not text, try

=A2+SEQUENCE(A6)

and format the column to show the date as you want.

I should have been more specific, and I am sorry. I'm trying to keep the same date through all of the lines.

 

[Fluff]

In that case use

=A2+SEQUENCE(A6,,,0)

 

[PuntingJawa]

In that case use

=A2+SEQUENCE(A6,,,0)

Thank you very much, and with this I have learned a couple of new formulas as well.

 

[Fluff]

You're welcome & thanks for the feedback.