How do I join 3 separate columns of dates
You can use the TEXT function:
=$C$1&": "&TEXT(C2,"d-mmm")&", "&$D$1&": "&TEXT(D2,"d-mmm")&", "&$E$1&":
"&TEXT(E2,"d-mmm")
HTH
Elkar
I want to join 3 separate date fields into one cell. Problem is it converts
the date to a serial number. How can I keep the date as a date and not as a
seriel number.
Example: 50: 16-Nov, 110: Sep-17, 180: 9-Jul
Formula: =$C$1&": "&C2&", "&$D$1&": "&D2&", "&$E$1&": "&E2
Result: 50: 39768, 110: 39708, 180: 39638
|