Excel Question - Concatenate and Dates

Factual Questions
1

I have a function in my worksheet:


=CONCATENATE("[REPLY: INSPECTED ",V5,"; ",BP5,"]")

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?

Thanks.

2

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


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

?

3

Substitute the V5 reference as follows:

TEXT(V5,“mm/dd/yy”)

You can adjust the formatting of the numbers accordingly.

4

That works. Thanks DWC.

5

Any time, glad to be of assistance.