Does anyone know how to make dates resolve into a date format not a number when using a "&" ?
Example: y2 and z2 contain dates. I want to display those values combined into 1 cell seperated by a dash.
Formula is: =y2&" - "&z2
result is "37337 - 37377" but I need result to be "3/22/2002 - 5/1/2002"
Thanks in advance..
Example: y2 and z2 contain dates. I want to display those values combined into 1 cell seperated by a dash.
Formula is: =y2&" - "&z2
result is "37337 - 37377" but I need result to be "3/22/2002 - 5/1/2002"
Thanks in advance..