Date issue

P

polk383

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!
 
D

David Biddulph

polk383 said:
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
Click to expand...

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")
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Arranging dates in a single column 5
Sum amount of days in another coloumn 8
Calculating pay dates 4
Complete Tax Years 1
2 dimensional date sort 1
Difference between two date/time values 5
help with datedif function please 4
separating date and time 5

Top