SOLVED

Date Reversal

%3CLINGO-SUB%20id%3D%22lingo-sub-3099467%22%20slang%3D%22en-US%22%3EDate%20Reversal%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3099467%22%20slang%3D%22en-US%22%3E%3CP%3EI%20regularly%20receive%20client%20spreadsheets%20where%20dates%20are%20listed%20as%2020000328%20(yyyymmdd)%20and%20have%20spent%20so%20much%20time%20trying%20to%20get%20it%20to%20convert%20to%2003282000%20(mmddyyyy).%20Or%20better%20yet%20mm%2Fdd%2Fyyyy.%20Is%20there%20anyway%20this%20can%20be%20done%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3099467%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3099590%22%20slang%3D%22en-US%22%3ERe%3A%20Date%20Reversal%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3099590%22%20slang%3D%22en-US%22%3ESuppose%20that%20date%20is%20in%20cell%20A2%3A%3CBR%20%2F%3E%3Ddate(left(a2%2C4)%2Cmid(a2%2C5%2C2)%2Cright(a2%2C2))%3C%2FLINGO-BODY%3E
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.