Converting Date

[srk0609]

I want to convert  2022-05-13 and 13-05-22 to 13-MAY-2022 can anyone help? Thank you

[DataNath]

Does this do the trick for you? The second formula is obviously optional, depending on whether or not you're precious about the uppercase 'MAY'. Workbook attached:

[srk0609]

Hi,

Is it possible to just have 13-MAY-22 instead of 13-MAY-2022 in o/p?

[DataNath]

@srk0609 Absolutely, just use lowercase y's here, as shown:

[srk0609]

Thank you let me try it. I will mark it as solution as soon as I get o/p

[srk0609]

Thank you the year thing and is it possible to show March as MAR, April APR in the same date eg o/p should 13-APR-22

[DataNath · Accepted solution]

Sure is @srk0609 - Just use a lowercase %h instead of %B, as shown here (have added a couple extra dates to show it working as MAY obviously doesn't change):

[binuacs]

@srk0609 Another way of doing this 

[srk0609]

Thank you so much for help