Extract Dates from String

5 views
Skip to first unread message

Vibhuti Shrotriya

unread,
May 13, 2016, 1:43:31 AM5/13/16
to Excel VBA Lab - An Excel VBA Macro help Group
Dear All,

How can I extract dates from the string? I have data like below in A Column.

Date Time
7/5/2016 11:26
8/5/2016 11:26
9/5/2016 11:26
10/5/2016 11:26


Required Output is :

7/5/2016
8/5/2016
9/5/2016
10/5/2016



Please share any formula.



Thanks
Vibhuti

Ashish Kumar

unread,
May 13, 2016, 3:07:43 AM5/13/16
to Excel VBA Lab - An Excel VBA Macro help Group
Hi,

Use this formula :


=+DATE(YEAR(A2),MONTH(A2),DAY(A2))



Regards
Ashish Kumar
Reply all
Reply to author
Forward
0 new messages