Thanks Thanks:  0
Likes Likes:  0
Results 1 to 4 of 4

Thread: Dates format when using "&"

  1. #1
    Board Regular
    Join Date
    Mar 2002
    Posts
    88
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Does anyone know how to make dates resolve into a date format not a number when using a "&" ?

    Example: y2 and z2 contain dates. I want to display those values combined into 1 cell seperated by a dash.

    Formula is: =y2&" - "&z2

    result is "37337 - 37377" but I need result to be "3/22/2002 - 5/1/2002"

    Thanks in advance..

  2. #2
    Board Regular
    Join Date
    Mar 2002
    Location
    Wellington
    Posts
    115
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi,

    You might want to try the following formula:

    =text(y2,"dd/mm/yyyy")&" - "&text(z2,"dd/mm/yyyy")

    HTH

  3. #3
    New Member
    Join Date
    Mar 2002
    Location
    Nanaimo, BC
    Posts
    49
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I used this formula recently:

    Make 2 supplementary cells with formulas like this:
    =TEXT(Y2,"mmddyyyy")
    =TEXT(Z2,"mmddyyyy")

    And then just concatenate like u did already.
    Hope that helps!
    Kyle

  4. #4
    Board Regular
    Join Date
    Mar 2002
    Posts
    88
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    worked perfect - thanks..

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •