Q. Convert the date from first format to the second format and sort in ascending order.

Occasional Contributor
Date (yyyymmdd.000)Date (mm/dd/yyyy)
20070623?
20070624?
20070523?
20061202?
20070112?
20070519?
20080419?
20071017?
20051220?
2 Replies

@Danny03 

Let's say the first date is in A2.

Enter the following formula in B2:

 

=DATE(LEFT(A2,4),MID(A2,5,2),MID(A2,7,2))

 

Fill down, then sort on column B (or on column A)