problem with dates
Find bottlenecks in your Excel workbooks
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 6 of 6

Thread: problem with 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 three combo boxes with the 1st containg the day, and the second containing the month and the third containing the year.
    The problem is that i must copy and paste the date to a seperate data base, however it is not possible to copy the date straight from the combo box. so i have made a link to a seperate cell, but i am unable to concatenate these three into one cell and format it as a date. The date setup that i want iss dd/mm/yyyy. Any help would be good.
    Thanx
    Craig

  2. #2
    Board Regular
    Join Date
    Feb 2002
    Location
    Where the wild roses grow
    Posts
    285
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    If you send me your email address I'll send you a little calendar that I made for a userform, which is quite cool. It does exactly what you want it to do

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

    Default

    hey thnx alot,

    my e-mail is
    craig_devlin@hotmail.com

  4. #4
    Board Regular
    Join Date
    Feb 2002
    Location
    Where the wild roses grow
    Posts
    285
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I've sent it, if you need to know anything about it, just ask

    Audiojoe
    Wow, look at us now, flowers in the window

  5. #5
    MrExcel MVP Aladin Akyurek's Avatar
    Join Date
    Feb 2002
    Location
    The Hague, NL
    Posts
    81,833
    Post Thanks / Like
    Mentioned
    12 Post(s)
    Tagged
    1 Thread(s)

    Default

    On 2002-04-11 01:29, Craig AS wrote:
    Hey,
    I have three combo boxes with the 1st containg the day, and the second containing the month and the third containing the year.
    The problem is that i must copy and paste the date to a seperate data base, however it is not possible to copy the date straight from the combo box. so i have made a link to a seperate cell, but i am unable to concatenate these three into one cell and format it as a date. The date setup that i want iss dd/mm/yyyy. Any help would be good.
    Thanx
    Craig
    I see I failed to post or it's just vanished.

    Here what I wanted to say.

    If you created the comboboxes thru Toolbars|Forms, and your cell links are, say, A1, B1, and C1 and associated input ranges, say, List1, List2, and List3, use:

    =DATE(INDEX(List3,C1),INDEX(List2,B1),INDEX(List1,A1))

    If A1, B1, and C1 contains the relevant values directly, use (as Ian Mac also noted):

    =DATE(C1,B1,A1)

    Aladin

    [ This Message was edited by: Aladin Akyurek on 2002-04-11 02:48 ]

  6. #6
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Newcastle, UK
    Posts
    1,174
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    On 2002-04-11 01:29, Craig AS wrote:
    Hey,
    I have three combo boxes with the 1st containg the day, and the second containing the month and the third containing the year.
    The problem is that i must copy and paste the date to a seperate data base, however it is not possible to copy the date straight from the combo box. so i have made a link to a seperate cell, but i am unable to concatenate these three into one cell and format it as a date. The date setup that i want iss dd/mm/yyyy. Any help would be good.
    Thanx
    Craig
    chack out the date function:

    =date(year,month,day)

    if your linked cells are

    A1 = Day
    A2 = Month
    A3 = Year... put:

    =date(A3,A2,A1)

    and format how you wish.
    "Have a good time......all the time"
    Ian Mac

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
  •  

 

 
DMCA.com