jnix612
09-05-2023, 08:53 AM
How do I fix the serial date to a formatted date after I've tried the traditional formatting options? I tried changing via the format cells using the date; I tried a custom date, and still it won't change. I changed to text and back to general, then a formatted date. Nothing works.
Here is the formula: =TEXTJOIN(";",TRUE,XLOOKUP($B2&$C2&G$1,CompletedTraing!$C$2:$C$400&CompletedTraing!$D$2:$D$400&CompletedTraing!$K$2:$K$400,CompletedTraing!$M$2:$M$400,"NC"))
In column F on the green table, the date is formatted correctly, there is no formula here.
I used this formula on another spreadsheet and the dates are formatted as dates (see blue table)
Attached screenshot (green) this is the problem spreadsheet.
Attached screenshot (blue) this is the same formula used on another spreadsheet and the dates are formatted as dates.
31024
31025
Here is the formula: =TEXTJOIN(";",TRUE,XLOOKUP($B2&$C2&G$1,CompletedTraing!$C$2:$C$400&CompletedTraing!$D$2:$D$400&CompletedTraing!$K$2:$K$400,CompletedTraing!$M$2:$M$400,"NC"))
In column F on the green table, the date is formatted correctly, there is no formula here.
I used this formula on another spreadsheet and the dates are formatted as dates (see blue table)
Attached screenshot (green) this is the problem spreadsheet.
Attached screenshot (blue) this is the same formula used on another spreadsheet and the dates are formatted as dates.
31024
31025