Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula for determining if two date columns fall within specific date range | Excel Worksheet Functions | |||
Formula for determining if two date columns fall within specific date range | Excel Discussion (Misc queries) | |||
Date format issue | Excel Worksheet Functions | |||
Another Date issue. | Excel Worksheet Functions | |||
Date conversion issue "^" symbol | Excel Discussion (Misc queries) |