SOLVED

Date Reversal

New Contributor

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?

3 Replies
best response confirmed by Shawn-UIA (New Contributor)
Solution
Suppose that date is in cell A2:
=date(left(a2,4),mid(a2,5,2),right(a2,2))
Thank you! I will give it a try.
Thank you so much for the help! This is EXACTLY what I needed.