Date Format Convert

[sadasivan]

Hi All

How to convert the date as like (From 01-Jan-24 To 01JAN24)
also attach data file

 

[ETAF]

you have a format set to
[$-en-PH]dd/mmm/yy;@
you can change to
[$-en-PH]ddmmmyy;@

 

[vletm]

sadasivan​

If You would like to convert Your A-column dates then
eg to cells C2 =TEXT(DAY(A2),"00") & UPPER(TEXT(MONTH(A2),"MMM")) & RIGHT(YEAR(A2),2)
above converts it as You've written
as well as it shows Months with capital letters.

 

[sadasivan]

you have a format set to
[$-en-PH]dd/mmm/yy;@
you can change to
[$-en-PH]ddmmmyy;@

not working

 

[sadasivan]

sadasivan​

If You would like to convert Your A-column dates then
eg to cells C2 =TEXT(DAY(A2),"00") & UPPER(TEXT(MONTH(A2),"MMM")) & RIGHT(YEAR(A2),2)
above converts it as You've written
as well as it shows Months with capital letters.

Its Working
Thank You Very Much

vletm​

 

[p45cal]

Its Working

Shorter:

=UPPER(TEXT(A2,"ddmmmyy"))