How to change Date Format in Column Header

Hi Fellows,

I have a sheet read from excel file with series of column header(more than 100) like “2023-06-13”, “2023-06-14” and need to output these header as the format of “06/13/23”.

I tried to transpose it to a column to change the format, but stuck when “string to date&time” required a column name, which don’t exist after transpose.

Great thanks in advance!