Looking at you last piece of code I see you'll be formatting column A to mm/dd/yyyy, if you do that before you run my code, it'll delete the lot on column A. But you know what you want.

Glad I helped you get to the desired outcome.