"each sheet is dated in cell A5 in mm/dd/yyyy format. Of course a sheet can't be named in this format"
"However the macro reed it in the original format mm/dd/yyyy"
you were almost there.
All you need to do now is let Excel know which format you want by using Format().
Monday, Tuesday and Thursday are usually the days I'll respond. Bear this in mind when awaiting a reply.