Formatting Date to MM-DD-YY while using CONCATENATE

[kbdavis11]

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.

I am aware you are all volunteers, so I do appreciate any assistance that could be provided.

 

[DebugGalpin]

replace B1 in your concatenate formula with

text(B1,"MM-DD-yy")

 

[kbdavis11]

replace B1 in your concatenate formula with

text(B1,"MM-DD-yy")

Works perfectly. Thanks so much!