Concatenate Dates

Corticus · May 3rd, 2002, 08:27 AM

Is there any way to concatenate dates and maintain the date property?

Right now I have:

="From "&I6&" through "&K6
which gives me:
From 37316 through 37346

Thanks
Corticus

Asala42 · May 3rd, 2002, 08:29 AM

Hey

Use the TEXT formula:

=TEXT(K6,"mm/dd/yy")&" through "&TEXT(I6,"mm/dd/yy")

Adam

IML · May 3rd, 2002, 08:29 AM

you can use
"From "&text(I6,"mm-dd-yy")&" through "&text(K6,"mm-dd-yy")

an adjust mm-dd-yy to suit.

Corticus · May 3rd, 2002, 08:56 AM

Thanks for the replies,
Worked Great!!!

You guys rock!

Corticus

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

May 3rd, 2002, 08:27 AM	#1
Corticus Board Regular Join Date: Apr 2002 Location: Sarasota, FL Posts: 1,539	Is there any way to concatenate dates and maintain the date property? Right now I have: ="From "&I6&" through "&K6 which gives me: From 37316 through 37346 Thanks Corticus

May 3rd, 2002, 08:29 AM	#2
Asala42 Board Regular Join Date: Feb 2002 Location: Southfield,MI USA Posts: 1,027	Hey Use the TEXT formula: =TEXT(K6,"mm/dd/yy")&" through "&TEXT(I6,"mm/dd/yy") Adam

May 3rd, 2002, 08:29 AM	#3
IML MrExcel MVP Join Date: Feb 2002 Location: Denver, CO Posts: 1,744	you can use "From "&text(I6,"mm-dd-yy")&" through "&text(K6,"mm-dd-yy") an adjust mm-dd-yy to suit.

May 3rd, 2002, 08:56 AM	#4
Corticus Board Regular Join Date: Apr 2002 Location: Sarasota, FL Posts: 1,539	Thanks for the replies, Worked Great!!! You guys rock! Corticus