Query related to date

[Excel]

Hello Everyone, 

I want to change date with the help of formula .

Here is a below screenshot:

Please help..

Here is a File Attached

[#2 · Accepted solution]

@Excel 

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

[#3]

 Try this.