Display date using ordinal numbering

[streets]

I desire an excel formula that will automatically update to today's date and that will display the day's digit as ordinal number. How to create it?

Today's date is Wednesday, September 18, 2024. The ordinal numbering endings of "st", "nd", "rd", or "th" is to be added to the end of day's digit, to auto-update to display as "Wednesday, September 18th, 2024" (without quote marks).

When the first of the month comes around, I'd like it to auto-update to Tuesday, October 1st, 2024. Then, following that, automatically update to Wednesday, October 2nd, 2024 and then Thursday, October 3rd, 2024, and so on, as the calendar goes-by.

 

[6StringJazzer]

I think this formula would not work correctly for day like 11, 12, 13, 21, 22, 23. It would add "st" to 11 for example.

Good catch. It does work for 21, 22, 23, but it will not work for 11-13. Needs work.