I want to convert 2022-05-13 and 13-05-22 to 13-MAY-2022 can anyone help? Thank you
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):
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:
Hi,
Is it possible to just have 13-MAY-22 instead of 13-MAY-2022 in o/p?
@srk0609 Absolutely, just use lowercase y's here, as shown:
Thank you let me try it. I will mark it as solution as soon as I get o/p
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
@srk0609 Another way of doing this
Thank you so much for help
