Date issue
 

Hey again... Hopefully this is not another stupid issue like last time.
Working with more than one worksheet and I am trying to pull two dates
into one cell. For example: Worksheet 1 - Cell A1 - has a date of
"06/03/05" and on worksheet 2 - Cell A1 - has a date of "06/04/05".
What I am looking for on Worksheet 3 Cell A1 to have "06/03/05" -
"06/04/05". I have formated everything to be mm/dd/yy and when I
attempt this i get a something that looks like this "38878-38886" I
was using the formula:
=Worksheet1!A1 & "-" & Worksheet2!A1

Once again thank you!


--
polk383
------------------------------------------------------------------------
polk383's Profile: http://www.excelforum.com/member.php...o&userid=34884
View this thread: http://www.excelforum.com/showthread...hreadid=550658

Date issue
 

=TEXT(Worksheet1!A1,"mm/dd/yy") & "-" & TEXT(Worksheet2!A1,"mm/dd/yy")

HTH
--
AP


"polk383" a écrit
dans le message de news:
...

Hey again... Hopefully this is not another stupid issue like last time.
Working with more than one worksheet and I am trying to pull two dates
into one cell. For example: Worksheet 1 - Cell A1 - has a date of
"06/03/05" and on worksheet 2 - Cell A1 - has a date of "06/04/05".
What I am looking for on Worksheet 3 Cell A1 to have "06/03/05" -
"06/04/05". I have formated everything to be mm/dd/yy and when I
attempt this i get a something that looks like this "38878-38886" I
was using the formula:
=Worksheet1!A1 & "-" & Worksheet2!A1

Once again thank you!


--
polk383
------------------------------------------------------------------------
polk383's Profile:
http://www.excelforum.com/member.php...o&userid=34884
View this thread: http://www.excelforum.com/showthread...hreadid=550658

Date issue
 

"polk383" wrote in
message ...

Hey again... Hopefully this is not another stupid issue like last time.
Working with more than one worksheet and I am trying to pull two dates
into one cell. For example: Worksheet 1 - Cell A1 - has a date of
"06/03/05" and on worksheet 2 - Cell A1 - has a date of "06/04/05".
What I am looking for on Worksheet 3 Cell A1 to have "06/03/05" -
"06/04/05". I have formated everything to be mm/dd/yy and when I
attempt this i get a something that looks like this "38878-38886" I
was using the formula:
=Worksheet1!A1 & "-" & Worksheet2!A1

Because you're wanting to produce a text string to concatenate, I think you
need something of the form
=TEXT(Worksheet1!A1,"mm/dd/yy")&"-"&TEXT(Worksheet2!A1,"mm/dd/yy")
--
David Biddulph

Date issue
 

Good deal! Thank you both! Works great! :)


--
polk383
------------------------------------------------------------------------
polk383's Profile: http://www.excelforum.com/member.php...o&userid=34884
View this thread: http://www.excelforum.com/showthread...hreadid=550658