Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Page 1 of 3 123 LastLast
Results 1 to 10 of 24

Thread: concatenate dates?

  1. #1
    New Member
    Join Date
    Mar 2002
    Posts
    26
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    hey,
    i have 3 combo boxes, first with day numbers, second with month names, and third with years. I was just waundering if it is possible to concatenate three cells as a date. I have tried but i cannot solve it. any help is appreciated, thnx alot

    Craig

  2. #2
    MrExcel MVP Aladin Akyurek's Avatar
    Join Date
    Feb 2002
    Location
    The Hague, NL
    Posts
    83,653
    Post Thanks / Like
    Mentioned
    33 Post(s)
    Tagged
    6 Thread(s)

    Default

    On 2002-04-27 05:55, Craig AS wrote:
    hey,
    i have 3 combo boxes, first with day numbers, second with month names, and third with years. I was just waundering if it is possible to concatenate three cells as a date. I have tried but i cannot solve it. any help is appreciated, thnx alot

    Craig
    Since you didn't tell how you created the comboboxes and whether or not the month names are full names or 3-letter names, what follows will simply use 3 cells (A1:C1)housing a day value (a number), a month (full) name, and a year value (a 4-digit) number, respectively:

    =DATE(C1,MATCH(B1,{"january";"february";"march";"april";"may";"june";"july";"august";"september";"october";"november";"december"},0),A1)

    For 3-latter names adjust:

    {"january";"february";"march";"april";"may";"june";"july";"august";"september";"october";"november";"december"}

    Aladin

  3. #3
    New Member
    Join Date
    Mar 2002
    Posts
    26
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    ok sorry, i will try and explain more clearly now:

    I have three combo boxes, the 1st contains day numbers 1-31. The second only contains months, 3 letters, so january = jan, febuary = feb ect.... and the the third contains this year and the upcoming year. 2002/2003, no next year it will contain 2003/2004. I have used vlookup formulas so it will look up the cell link, the show jan,feb etc.. in a cell. I have done the same for the years. However i need to transfer all the ordering information to a database on excel, but cannot find a way to get the three seperate cells of information(day,moth,yaer) into one single cell. hope this makes my problem more clear. Thanx alot

    Craig

    p.s. didnt understand your reply

  4. #4
    MrExcel MVP Aladin Akyurek's Avatar
    Join Date
    Feb 2002
    Location
    The Hague, NL
    Posts
    83,653
    Post Thanks / Like
    Mentioned
    33 Post(s)
    Tagged
    6 Thread(s)

    Default

    On 2002-04-27 06:39, Craig AS wrote:
    ok sorry, i will try and explain more clearly now:

    I have three combo boxes, the 1st contains day numbers 1-31. The second only contains months, 3 letters, so january = jan, febuary = feb ect.... and the the third contains this year and the upcoming year. 2002/2003, no next year it will contain 2003/2004. I have used vlookup formulas so it will look up the cell link, the show jan,feb etc.. in a cell. I have done the same for the years. However i need to transfer all the ordering information to a database on excel, but cannot find a way to get the three seperate cells of information(day,moth,yaer) into one single cell. hope this makes my problem more clear. Thanx alot

    Craig

    p.s. didnt understand your reply
    What are your cell links? Do these show directly the selections made?

    Aladin

  5. #5
    New Member
    Join Date
    Mar 2002
    Posts
    26
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    hi,
    my cell links was just the number relating to what i chose. e.g. january = 1, febuary = 2 march = 3, etc..... then i just looked up a table with dates in to get the date in a word(3 letters)

  6. #6
    MrExcel MVP Aladin Akyurek's Avatar
    Join Date
    Feb 2002
    Location
    The Hague, NL
    Posts
    83,653
    Post Thanks / Like
    Mentioned
    33 Post(s)
    Tagged
    6 Thread(s)

    Default


    p.s. didnt understand your reply


    Craig,

    By the way, Why don't you check the formula I provided by entering in A1, say, 27, in B1 "April" without quotes, and C1 2002 to see if it works and how it works? The formula must go say in D1.

    Aladin


    [ This Message was edited by: Aladin Akyurek on 2002-04-27 07:05 ]

  7. #7
    New Member
    Join Date
    Mar 2002
    Posts
    26
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default



    [ This Message was edited by: Craig AS on 2002-04-27 08:21 ]

  8. #8
    New Member
    Join Date
    Mar 2002
    Posts
    26
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hey again,

    sorry to bother u again, but i have found a problem with it. for some reason it will not work with the year. #NUM! comes up in the cell. it works without the year, but the year come up as 1990 all the time, so its definetly got something 2 do with the year, but i dont know what, ne ideas?

    Craig

  9. #9
    MrExcel MVP Aladin Akyurek's Avatar
    Join Date
    Feb 2002
    Location
    The Hague, NL
    Posts
    83,653
    Post Thanks / Like
    Mentioned
    33 Post(s)
    Tagged
    6 Thread(s)

    Default

    On 2002-04-27 08:12, Craig AS wrote:


    [ This Message was edited by: Craig AS on 2002-04-27 08:21 ]
    You emptied this post!

    Do you need any further assistance?

    Aladin

  10. #10
    New Member
    Join Date
    Mar 2002
    Posts
    26
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    On 2002-04-27 08:26, Craig AS wrote:
    Hey again,

    sorry to bother u again, but i have found a problem with it. for some reason it will not work with the year. #NUM! comes up in the cell. it works without the year, but the year come up as 1900 all the time, so its definetly got something 2 do with the year, but i dont know what, ne ideas?

    Craig
    yes i do, with the above please.

    [ This Message was edited by: Craig AS on 2002-04-27 08:33 ]

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
  •