Concat Date As Text

Question

I am attempting the following formula:

=concatenate(A1, " ", B1, " - ", C1)

Where column A is text, B and C are dates. The concatenate function returns the numerical value of the date, rather than the text value. How do I fix this?

Answer 1

You can use TEXT

=CONCATENATE(A1," ",TEXT(B1,"dd mmm yyyy")," - ",TEXT(C1,"dd/mm/yyyy"))