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

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

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:


1 Like

I want it to show like this.

29/Mar/2021

1 Like

Is TEXT() not giving you that result?

try:

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

1 Like