Jun 04 2022 03:01 AM - edited Jun 04 2022 03:42 AM
Hello Everyone,
I want to change date with the help of formula .
Here is a below screenshot:
Please help..
Here is a File Attached
Jun 04 2022 03:49 AM
SolutionIt works slightly differently:
eleventh -> 11th, not 11st.
twelfth ->12th, not 12nd.
Use:
=DAY(A1)&IF(AND(DAY(A1)>10, DAY(A1)<14), "th", CHOOSE(MOD(DAY(A1),10)+1, "th", "st", "nd", "rd", "th", "th", "th", "th", "th", "th"))&TEXT(A1, " mmm yyyy")
Jun 04 2022 03:49 AM
SolutionIt works slightly differently:
eleventh -> 11th, not 11st.
twelfth ->12th, not 12nd.
Use:
=DAY(A1)&IF(AND(DAY(A1)>10, DAY(A1)<14), "th", CHOOSE(MOD(DAY(A1),10)+1, "th", "st", "nd", "rd", "th", "th", "th", "th", "th", "th"))&TEXT(A1, " mmm yyyy")