Excel Question - Concatenate and Dates

I have a function in my worksheet:


where cell V5 refers to a cell formatted as a date. The results of my formula are:

As you can see, Excel converts the date recorded in V5 to a serial number (in this case 39097 which is 1/15/07) when placing that the value of V5 into the concatenated string. How can I force the serial number to appear as a date in the string?


I don’t have Excel on this computer, but did you try something like

year (v5), "/", month (v5), "/", day (v5)


Substitute the V5 reference as follows:


You can adjust the formatting of the numbers accordingly.

That works. Thanks DWC.

Any time, glad to be of assistance.