ExcelBanter - Converting a date from nonsense to sense

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Converting a date from nonsense to sense (https://www.excelbanter.com/excel-discussion-misc-queries/84791-converting-date-nonsense-sense.html)

RobertM

Converting a date from nonsense to sense

How do I convert this date "060426" to "4/26/2006"

Gary Brown

Converting a date from nonsense to sense

Assuming the 060426 is in cell A1, type the following formula:-

=DATE(20&LEFT(A1,2),MID(A1,3,2),RIGHT(A1,2))

Then format this cell with a format M/DD/YYYY

--
Gary Brown
------------------------------------------------------------------------
Gary Brown's Profile: http://www.excelforum.com/member.php...o&userid=17084
View this thread: http://www.excelforum.com/showthread...hreadid=535499

All times are GMT +1. The time now is 04:34 AM.