Textjoin dates and ignoring blanks

[Ewal]

Hello,

I'm trying to use the textjoin function to combine multiple dates into one cell and ignore blank cell. I was able to get to work using this function =TEXTJOIN(",",TRUE,D8:P8) but it brough the dates over in a number format like 44655, 44683, 44718. I want it to look like this 4/4/22, 5/2/22, 6/6/22. I tried to use the formula like this =TEXTJOIN(" ",TRUE,TEXT(D5:P5,"mm/dd/yy")) but it didn't ignore the blank cells and it look like this

. How do I write the formula to get rid of 01/00/00 and only keep the dates I want?

 

[Fluff]

Hi & welcome to MrExcel.
How about

=TEXTJOIN(" ",,IF(D5:P5="","",TEXT(D5:P5,"mm/dd/yy")))

 

[Ewal]

It worked!! Thank you so much this helps out a lot.

 

[Fluff]

You're welcome & thanks for the feedback.

 

[tommatwalker]

Hi I realise that this is quite an old post but I have exactly the same issue except that when I try this fix I now only return one blank value (i.e. 00/01/1900)? Would it make a difference that I am using data in one column rather than one row?

TIA

 

[Fluff]

What is the formula you used & did you confirm it with Ctrl Shift Enter?

 

[tommatwalker]

Apologies I have since got the formula to work (typo on my end) sorry I thought I had got on and deleted my comment.

Thanks again

 

[Fluff]

Glad you sorted it & thanks for letting us know.