When the date field is concatenated with any text field in excel, in the result field the date formate may change. The date value may also be converted to some other format. To avoid this convert the date field to the text field while concatenating.
Ex: COCATENATE(TEXT(C2,”dd/mm/yyyy”),E2)
In this formula, the date value in C2 converts to dd/mm/yyyy format and then concatenates this value with the value in E2. You can use any other format for the date field.
A sample screenshot is attached below
