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 ther...
- Suppose that date is in cell A2:
=date(left(a2,4),mid(a2,5,2),right(a2,2))
Suppose that date is in cell A2:
=date(left(a2,4),mid(a2,5,2),right(a2,2))
=date(left(a2,4),mid(a2,5,2),right(a2,2))
Thank you so much for the help! This is EXACTLY what I needed. 🙂