Forum Discussion
Q. Convert the date from first format to the second format and sort in ascending order.
Date (yyyymmdd.000) Date (mm/dd/yyyy) 20070623 ? 20070624 ? 20070523 ? 20061202 ? 20070112 ? 20070519 ? 20080419 ? 20071017 ? 20051220 ?
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)
- thankyou
