I'm using the following date format:
D MMMM YYYY
To display today's date: 5 October 2017
I can do the following to add the ordinal:
D\th MMMM YYYY
5th October 2017
But obviously this won't work correctly for e.g. 1st October 2017
Is there a way?
Adapted from https://akntechblog.wordpress.com/201...
=DAY(TODAY())&IF(OR(DAY(TODAY())={1;2;3;21;22;23;31}); CHOOSE(1*RIGHT(DAY(TODAY());1);"st";"nd ";"rd ");"th ") &TEXT(TODAY();"mmmm yyyy")
See also @Lupp's answer at https://ask.libreoffice.org/en/questi...
Asked: 2017-10-05 12:42:50 +0100
Seen: 191 times
Last updated: Oct 05 '17
Content on this site is licensed under a Creative Commons Attribution Share Alike 3.0 license.
No, I hope.
However, if there is one it will heavily depend on the locale, and as far as I can tell the many
'English (somehing)'locales may act differently. In the UK itself it is uncommon to use an ordinal mark in written dates. There may be thousands of excessively stubborn ways to write dates in the English speaking world.Your
D\th MMMM YYYYdoes not work for me withUI=locale=DocLanguage= English (UK). Thehis taken for "hour".