I removed the "textjoin" from the formula. Now it will allow me to change the serial date to a formatted date.

What's odd, in my original spreadsheet I used the textjoin and it allowed the date to be formatted as a date.

I also can't recall why I used the textjoin with the xlookup. I did not need the textjoin.