join a list of date

linkn00

New Member
Joined
Aug 15, 2019
Messages
20
Office Version
365
Platform
Windows
I want to join a list of date together quickly. the join function requires the text function for every single date.
Is there an easier way to join a list of date together?
 

Some videos you may like

Excel Facts

Formula for Yesterday
Name Manager, New Name. Yesterday =TODAY()-1. OK. Then, use =YESTERDAY in any cell. Tomorrow could be =TODAY()+1.

Rick Rothstein

MrExcel MVP
Joined
Apr 18, 2011
Messages
36,203
Office Version
2010
Platform
Windows
You have left some important information out of your post... where is the list of dates? how do you want them joined? where do you want the output to go to?

Just guessing here... I'll assume your dates are in cells A1:A10, that your want the output to be m/d/yyyy forma, that you want them joined using a comma/space as the delimiter and that you want the output to be shown in a MessageBox... here is a macro that will do this
Code:
Sub DateLister
  MsgBox Join(Application.Transpose(Evaluate("IF({1},TEXT(A1:A10,""m/d/yyyy""))")), ", ")
End Sub
 

linkn00

New Member
Joined
Aug 15, 2019
Messages
20
Office Version
365
Platform
Windows
Is there away to do it without using VBA?
 

Rick Rothstein

MrExcel MVP
Joined
Apr 18, 2011
Messages
36,203
Office Version
2010
Platform
Windows
Is there away to do it without using VBA?
I am not sure... my version of Excel is 2010... some of the later versions have a function called TEXTJOIN which I think would work the same way I used Join (except you should not have to TRANSPOSE the array result), but I am not sure and have no way to test it. If your version of Excel has this function, then I think the answer is "yes" and if you can figure it out yourself, great; otherwise you will have to wait for someone to come along who has that function in their version of Excel in order to show you the way.
 

Peter_SSs

MrExcel MVP, Moderator
Joined
May 28, 2005
Messages
45,918
Office Version
365
Platform
Windows

ADVERTISEMENT

Welcome to the MrExcel board!

Rick pointed out that you have omitted some information from your post and you still have not provided that information.
You have left some important information out of your post... where is the list of dates? how do you want them joined? where do you want the output to go to?
You also mentioned the "join function" which is a function in vba, not worksheet functions, so it is not surprising that a vba suggestion was made. ;)

So, still guessing at some of the things Rick asked, see if this formula helps. It is an array formula so should be entered without the {} but confirmed with Ctrl+Shift+Enter, not just Enter. If confirmed correctly, Excel will insert the {}.

Excel Workbook
BC
12-May-182-May-18, 25-Dec-17, 15-Oct-19
225-Dec-17
315-Oct-19
Join dates
 

linkn00

New Member
Joined
Aug 15, 2019
Messages
20
Office Version
365
Platform
Windows
Thanks so much, exactly what i am looking for
 

Subscribe on YouTube

Watch MrExcel Video

Forum statistics

Threads
1,106,338
Messages
5,510,701
Members
408,808
Latest member
TheTomar

This Week's Hot Topics

  • Turn fraction around
    Hello I need to turn a fraction around, for example I have 1/3 but I need to present as 3/1
  • TIme Clock record reformatting to ???
    Hello All, I'd like some help formatting this (Tbl-A)(Loaded via Power Query) [ATTACH type="full" width="511px" alt="PQdata.png"]22252[/ATTACH]...
  • TextBox Match
    hi, I am having a few issues with my code below, what I need it to do is when they enter a value in textbox8 (QTY) either 1,2 or 3 the 3 textboxes...
  • Using Large function based on Multiple Criteria
    Hello, I can't seem to get a Large formula to work based on two criteria's. I can easily get a oldest value based one value, but I'm struggling...
  • Can you check my code please
    Hi, Im going round in circles with a Compil Error End With Without With Here is the code [CODE=rich] Private Sub...
  • Combining 2 pivot tables into 1 chart
    Hello everyone, My question sounds simple but I do not know the answer. I have 2 pivot tables and 2 charts that go with this. However I want to...
Top