Converting column header from string to desired date format

[Sujithappaiah]

Looking for some help to understand how I can convert the headings which are currently in String format to Date format (Should be in this format: 18-Jan-2021).

Also looking to get an idea on the best way to format and remove the .3 or data appearing after the 2nd "." in the Names of countries such that I am only remaining with Australia.AUS rather than Australia.AUS.2

[Sujithappaiah]

Attaching the data

[Kamran1991]

Hope this will help you

[Qiu]

@Sujithappaiah 
Dynamic Rename should be a good fit here.

[Ben_H]

There looks to be an error in the formula there -

It should be "%d-%b-%Y" instead of "%m-%b-%Y"

Regards,

Ben