Sub DateLister
MsgBox Join(Application.Transpose(Evaluate("IF({1},TEXT(A1:A10,""m/d/yyyy""))")), ", ")
End Sub
Is there away to do it without using VBA?
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?
Excel Workbook | ||||
---|---|---|---|---|
B | C | |||
1 | 2-May-18 | 2-May-18, 25-Dec-17, 15-Oct-19 | ||
2 | 25-Dec-17 | |||
3 | 15-Oct-19 | |||
Join dates |