Skip to main content

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

The format specifiers for DATETIME_FORMAT() are available here:





You want to use the “ordinal” options.

Reply


Terms & Conditions