Formula for Including "st" "nd" "rd" "th" in Dates

[Tom_Blanchard]

Hi, Does anyone have a formula to format a date to include the “st” “nd” “rd” “th” ?

For example, I would like 3/21/2022 to read as Monday, March 22nd

I can only figure out how to do Monday, March 22

Thanks!
Tom

[Kamille_Parks · Accepted solution]

The format specifiers for DATETIME_FORMAT() are available here:

Airtable Support

Supported format specifiers for DATETIME_FORMAT

The DATETIME_FORMAT function will allow you to reformat the data from the date-type field into a string of your specifications. This is written in the format of DATETIME_FORMAT(Datetime, 'format sp...

You want to use the “ordinal” options.