I have been trying to convert a date (Scheduled Delivery Date: Tue, Feb 4 by 3:00 PM) to a proper date format (mm/dd/yyy) format in each row in excel.
Date format in excel:
Data will be in multiple sheets and no. of rows may vary for each sheet, I have tried few codes to get this but nothing worked for me.
I’m attaching the Input excel below can anyone please help me out with this asap.
input.xlsx (8.7 KB)