Forum Discussion
Solved
Date Reversal
I regularly receive client spreadsheets where dates are listed as 20000328 (yyyymmdd) and have spent so much time trying to get it to convert to 03282000 (mmddyyyy). Or better yet mm/dd/yyyy. Is there anyway this can be done?
- Suppose that date is in cell A2:
=date(left(a2,4),mid(a2,5,2),right(a2,2))
3 Replies
- Suppose that date is in cell A2:
=date(left(a2,4),mid(a2,5,2),right(a2,2))
