Formatting Date to MM-DD-YY while using CONCATENATE

Hello everyone,

I am having difficulties with a date properly formatting while I am using the CONCATENATE formula.

I have a date in cell B1, which is formatted correctly, and there are also multiple unrelated cells from B2 - B10 that are "input" cells.

I am using A15 to with a concatenate formula to basically combine all these cells to a format that is required by my company. The problem is, I am not entirely sure how I can take the date from cell B1 and format it to MM-DD-YY while using the CONCATENATE formula.

Any suggestions?

Side note, the "input" cells from B1:B10 are not all dates. Some are $$ amounts, some are percentages, and some are simply just text (so I cannot format everything in this formula to date format)

Also, if I must I would even be willing to separate the dates using the "MONTH(B1)", "DAY(B1)", and "YEAR(B1)" into separate cells on the sheet and then somehow combine them if needed.

Thanks for the help. It worked!