Convert date 19/08/2024 to Mon 19th Aug 2024

[Sundance_Kid]

Hi,
As per my thread title is it possible to convert a date to something like Mon 19th Aug 2024?

Thank you

 

[RoryA]

If you need the "th" after the day number, then the formula gets more complicated; if that's not important then the TEXT function is simple:

=TEXT(A2,"ddd d mmm yyyy")

for example.

 

[plettieri]

This might work... assuming your cell of interest is in A1. as 8/19/24

=TEXT(A1, "ddd ") & DAY(A1) & CHOOSE(MIN(4, IF(AND(DAY(A1) > 3, DAY(A1) < 21), 4, MOD(DAY(A1), 10))), "st", "nd", "rd", "th") & TEXT(A1, " mmm yyyy")

plettieri

 

[Sundance_Kid]

Thank you both above, I was able to get to a solution with your help.