Converting Date in a string to a proper date format(mm/dd/yyyy) in excel

Hello everyone,

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)


@varma Where do you want to put the Converted Date?

To the same cell.
It has to rewrite in that cell with mm/dd/yyy format.

@varma Try This (13.5 KB)

@supermanPunch Thank you so much for the help :smiley:

1 Like

@supermanPunch can we write bold text in excel?

@varma It’s Possible using UI Automations :sweat_smile:

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.