Thread: Date issue
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
polk383
 
Posts: n/a
Default 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