TEXTJOIN and Dates

[phalcon45]

He everyone, Im trying to build a formula that finds all values that correlate to a search criteria then puts all of them in a single cell.
For example, it looks up a job number and reports all of the dates where the job number occurs.
I've been able to get it to report all of the dates BUT TEXTJOIN is reporting them as numbers instead of dates. For example job number AX11034 was worked on 9/27/2021, 9/28/2021 and 10/1/2021. TEXTJOIN finds all three dates but reports them as 43735, 44467, 44470. I've tried everything I can think of (including cell is formatted as Date mm/dd/yyyy) but nothing seems to work.
How can I get it to report the dates in a mm/dd/yyyy format?

Any help would be REALLY appreciated

Thank you

 

[Rick Rothstein]

You need to apply the TEXT function, using the date format you want, to the individual dates that are being joined. If you had posted your TEXTJOIN formula, we could give you specific help how to do this.

 

[phalcon45]

Thanks. I tried the TEXT function but try as I did, I apparently couldn't get it right.
My TEXTJOIN formula is simply TEXTJOIN(", ", TRUE, IF(M7=I2:I2000,C2:C2000,""))

 

[Rick Rothstein]

Try this formula...

=TEXTJOIN(", ", TRUE, IF(M7=I2:I2000,TEXT(C2:C2000,"mm/dd/yyyy"),""))

 

[phalcon45]

You sir are AMAZING!
Thank you!!!

 

[Joe4]

I re-marked Rick's post as the solution.
When marking a solution, you want to mark the post that actually contains the solution (not the post acknowledging that there is a solution).