date converts to serial number in formula

[PTH1]

I'm using a formula to pull data from other columns in order to automatically complete a phrase. The formula looks like ="language" & A1 & "other language" & B1, with A1 being the date. The date displays in standard date format in A1, but once used in the formula, it converts to the serial number. I've changed the number formatting in both columns (so that there are no /s or -s,) several times, to no avail. does anyone have suggestions?

 

[VoG]

Try

="language" & TEXT(A1,"dd/mm/yyyy") & "other language" & TEXT(B1,"dd/mm/yyyy")

 

[sous2817]

Hello and welcome to the board!

try somethign like (not tested):

="language" & Text(A1,"yyyy-mm-dd") & "other language" & B1

 

[PTH1]

thank you so much! this worked out perfectly!