Forum Discussion
Solved
Convert Date/Time String to Date Format
I am seeking assistance with converting a string that is a date/time value into a date format in Excel. I would like to use this field along with associated data in a pivot table to group by day, we...
You may convert text to date by formula like
=DATE( RIGHT(A2,4), MONTH( 1&LEFT( RIGHT(A2, LEN(A2) -4), 3) ), LEFT( RIGHT(A2, LEN(A2) -8), 2))and apply to result any date format you wish.
You may convert text to date by formula like
=DATE(
RIGHT(A2,4),
MONTH( 1&LEFT( RIGHT(A2, LEN(A2) -4), 3) ),
LEFT( RIGHT(A2, LEN(A2) -8), 2))and apply to result any date format you wish.
