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 | ? |
2 Replies
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
