Converting Text to Dates

[OxonLad]

Some of our company systems output dates in the format yyyymmdd but in a
"general" format eg 20080625 for the 25th June 2008. How can I convert this
to a date so I can use the day(), month(), year() functions?

At the moment I am using left(), mid(), right() to break up the text string
but there must be an easier way

Thank You

 

[Gary''s Student]

=DATE(LEFT(A1,4),MID(A1,5,2),RIGHT(A1,2)) and format the cell as Date

 

[Teethless mama]

Data > Text to Columns > Next > Next > Select Date: YMD > Finish out

 

[David Biddulph]

Data/ Text to Colums/ Delimited/ Next/ Next/ Date : YMD

 

[Rick Rothstein \(MVP - VB\)]

Here is another way to do it via a formula...

=--TEXT(A1,"0000-00-00")

Rick