Results 1 to 5 of 5

Thread: Concatenate formula for dates

  1. #1
    Board Regular willow1985's Avatar
    Join Date
    Jul 2019
    Location
    Winnipeg, MB
    Posts
    223
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default Concatenate formula for dates

    I have 2 columns (K and L) with the dates in the format: 08/27/2019 & 08/29/2019.

    I want to use a Concatenate formula to have the end result showing: Aug 27 - Aug 29.
    The formula I wrote is as follows:

    =CONCATENATE(TEXT(K3,"[$-409]mmm d;@")," - ",(TEXT(L3,"[$-409]mmm d;@")))

    However this formula is producing this as the result and I do not understand why:

    08/27/2019 - 08/29/2019

    I would also like to have the formula return a blank result if K or L are blank.

    Hope you guys can help me on this.

    Thank you

    Carla

  2. #2
    MrExcel MVP
    Join Date
    May 2009
    Posts
    16,590
    Post Thanks / Like
    Mentioned
    39 Post(s)
    Tagged
    9 Thread(s)

    Default Re: Concatenate formula for dates

    Sheet1

    K L M
    1 8/27/2019 8/29/2019 Aug 27-Aug 29

    Spreadsheet Formulas
    Cell Formula
    M1 ==IF(COUNT(K1:L1)<>2,"",TEXT(K1,"mmm dd")&"-"&TEXT(L1,"mmm dd"))


    Excel tables to the web >> Excel Jeanie HTML 4
    Last edited by JoeMo; Sep 12th, 2019 at 04:11 PM.
    Joe

    When I was a young man I knew everything. Now that I'm older, I realize I know very little, and what I do know, I tend to forget!

  3. #3
    Board Regular
    Join Date
    Jul 2014
    Location
    Memphis, TN
    Posts
    2,681
    Post Thanks / Like
    Mentioned
    11 Post(s)
    Tagged
    1 Thread(s)

    Default Re: Concatenate formula for dates

    Code:
    =TEXT(K3,"mmm dd") & " - " & TEXT(L3,"mmm dd")
    Excel 2013, 2016 with PowerBI
    Knowing that it can be done is half the battle!

  4. #4
    Board Regular willow1985's Avatar
    Join Date
    Jul 2019
    Location
    Winnipeg, MB
    Posts
    223
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Concatenate formula for dates

    This works perfectly, Thank you!

  5. #5
    Board Regular willow1985's Avatar
    Join Date
    Jul 2019
    Location
    Winnipeg, MB
    Posts
    223
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Concatenate formula for dates

    This formula is a lot simpler. Thank you very much!

Some videos you may like

User Tag List

Tags for this Thread

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
  •