SOLVED

Query related to date

Super Contributor

Hello Everyone, 

 

I want to change date with the help of formula .

Here is a below screenshot:

Screenshot (305).png

 

 

Please help..

 

Here is a File Attached

2 Replies
best response confirmed by Zain123 (Super Contributor)
Solution

@Zain123 

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")

 Try this.