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

Help
,
1

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:
image

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)

Regards,

2

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

3

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

4

@varma Try This ChangeDateFormat.zip (13.5 KB)

5

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

1 Like
6

@supermanPunch can we write bold text in excel?

7

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

8

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