ExcelBanter - Date Conversion

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

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

- - Date Conversion (https://www.excelbanter.com/excel-discussion-misc-queries/259267-date-conversion.html)

terry

Date Conversion

How do I convert a data string date when it imports as yymmdd to full date
description.

example
100115 need to convert to Jan 15, 2010
91210 need to convert to Dec 10,2009

Bob Phillips[_4_]

Date Conversion

Try

=DATE(2000+LEFT(A1,LEN(A1)-4),MID(A1,LEN(A1)-3,2),RIGHT(A1,2))

--

HTH

Bob

"Terry" wrote in message
...
How do I convert a data string date when it imports as yymmdd to full date
description.

example
100115 need to convert to Jan 15, 2010
91210 need to convert to Dec 10,2009

All times are GMT +1. The time now is 02:21 PM.