Forum Discussion
Solved
Query related to date
Hello Everyone, I want to change date with the help of formula . Here is a below screenshot: Please help.. Here is a File Attached
It 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")
It 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")