TEXTJOIN function is available in Excel for Office 365, Excel 2019, and Excel 2021. The syntax of the TEXTJOIN function is as follows: TEXTJOIN(delimiter, ignore_empty, text1, [text2], …) Where, ...

That’s just a few to consider. The only thing that limits the possibilities is your knowledge of these date formats. This use is simple, but not intuitive because you must add the TEXT () function.