Help

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

Topic Labels: Formulas
Solved
Jump to Solution
580 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Tom_Blanchard
5 - Automation Enthusiast
5 - Automation Enthusiast

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

1 Solution

Accepted Solutions
Kamille_Parks
16 - Uranus
16 - Uranus

The format specifiers for DATETIME_FORMAT() are available here:

You want to use the “ordinal” options.

See Solution in Thread

1 Reply 1
Kamille_Parks
16 - Uranus
16 - Uranus

The format specifiers for DATETIME_FORMAT() are available here:

You want to use the “ordinal” options.