This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Accept
Reject
Preferences
Log in to ask a question
Log in to ask a question

TEXT() day of month to include "st", "rd", and "th" - aka: "1st", "3rd", and "5th"

Posted on 11-05-2022 08:55 AM
MultiTech
Gold 4
Gold 4

MultiTech_0-1667663545872.png

It would be nice if the TEXT() formatting had a way to include some of the suffixes commonly applied to date days:

  • 1st - includes the "st"
  • 3rd - includes the "rd"
  • 5th - includes the "th"

If there was an argument option for the TEXT() formula to include these, it would make some labels look cleaner

--------------------------------------------------------------------------------------------------------------------
Cheers; and as always, thanks for considering!Small moonwalker.gif

Status Open
2 0 55
Idea Labels
Ideas by Status