Date Format Lost When Combining Two Cells Using "&" and CONCATENATE in Google Sheets

Question

I'm trying to figure out "how to" maintain the date format when I concatenate a date formatted cell with a nondate formatted cell.

Result: The Date Format Is Lost

Formulas Used

Desired Result: I had to convert Date format to Text Only

I'm trying to figure out "how to" maintain the Date Format while combining two cell values. Any ideas?

Answer 1

You can do the formatting on the fly:

=text(B2,"m/d/yyyy")&C2

---

Google Sheets Help: TEXT()