Add ordinal to date

[charlesstricklin]

I'm stumped. I have a column B which has dates in the format "Wednesday, March 15, 2023". I'd like the cells in column C to show a date like that as "Wednesday, March 15th, 2023"

 

[awoohaw]

Here is putting the "th" on. But it won't put on "nd" and "st"

You could probably use some conditionals with a text version.

 

[Joe4]

The most common solutions involve VBA.
You can find a whole bunch of threads on them (so you don't need to create the code yourself).
Here is one here: Formatting Ordinal Numbers