Convert date starting from day month year by the month using the English name

[fon1]

Converted as follows
d/mmm/yyyy

The formula used now is from start MMM/D/YYYY.

Ask permission tags

สตีฟ คอยล์
Dave Papajcikci
WillowMobileSystemsจอห์น แบร์
Kirk_Masden
เลเวนท์ คูลาโคกลู
Aleksi Alkio

[MultiTech]

I’m not sure what’s going on here… is this a question?

You should be able to use TEXT() to format the date into the format you want; as you’ve pointed out:

fon:

MMM/D/YYYY.

---

[fon1]

I want it to show like this.

29/Mar/2021

[MultiTech]

Is TEXT() not giving you that result?

try:

TEXT(..., "DD/MMM/YYYY")