Thanks Thanks:  0
Likes Likes:  0
Page 3 of 3 FirstFirst 123
Results 21 to 24 of 24

Thread: concatenate dates?

  1. #21
    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-28 09:46, Craig AS wrote:
    hey,

    ok i'll send my work, u have wuzip dont u? coz my file wont fit otherwise. Ne way, thanx alot.

    Craig
    Yes, I do.

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

    Default

    have u had my project ok?

  3. #23
    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-28 10:30, Craig AS wrote:
    have u had my project ok?
    Looks good.

    I named your 1-column list of day numbers in Places DLIST, your 1-column list of 3-letter month names MLIST, and your 1-column list of years YLIST.

    Guess what: You didn't tell that YLIST is populated by using formulas that compute a date by referring to a cell containing =TODAY(), which means that the first item is in fact in that list is today's date and not simply 2002. You should have told that .

    I replaced the Input range values in all of your comboboxes by their respective names.

    The formula for the departure date becomes simply:

    =DATE(YEAR(INDEX(YLIST,D29)),C29,B29)

    and for the return date:

    =DATE(YEAR(INDEX(YLIST,D31)),C31,B31)

    Aladin

    PS. I'll send you your updated WB back.

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

    Default

    hey thnx alot 4 that

    it works gr8, thanx alot again

    craig

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
  •