Dates format when using "&"

keith · Mar 24th, 2002, 09:00 PM

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..

BabyTiger · Mar 24th, 2002, 09:03 PM

Hi,

You might want to try the following formula:

=text(y2,"dd/mm/yyyy")&" - "&text(z2,"dd/mm/yyyy")

HTH

kwaring · Mar 24th, 2002, 09:06 PM

I used this formula recently:

Make 2 supplementary cells with formulas like this:
=TEXT(Y2,"mmddyyyy")
=TEXT(Z2,"mmddyyyy")

And then just concatenate like u did already.
Hope that helps!
Kyle

keith · Mar 24th, 2002, 09:07 PM

worked perfect - thanks..

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 24th, 2002, 09:00 PM	#1
keith Board Regular Join Date: Mar 2002 Posts: 88	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..

Mar 24th, 2002, 09:03 PM	#2
BabyTiger Board Regular Join Date: Mar 2002 Location: Wellington Posts: 104	Hi, You might want to try the following formula: =text(y2,"dd/mm/yyyy")&" - "&text(z2,"dd/mm/yyyy") HTH

Mar 24th, 2002, 09:06 PM	#3
kwaring New Member Join Date: Mar 2002 Location: Nanaimo, BC Posts: 49	I used this formula recently: Make 2 supplementary cells with formulas like this: =TEXT(Y2,"mmddyyyy") =TEXT(Z2,"mmddyyyy") And then just concatenate like u did already. Hope that helps! Kyle

Mar 24th, 2002, 09:07 PM	#4
keith Board Regular Join Date: Mar 2002 Posts: 88	worked perfect - thanks..