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

=DATE(LEFT(A1,4),MID(A1,5,2),RIGHT(A1,2)) and format the cell as Date
--
Gary''s Student - gsnu200793


"OxonLad" wrote:

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

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


"OxonLad" wrote:

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

Data/ Text to Colums/ Delimited/ Next/ Next/ Date : YMD
--
David Biddulph

"OxonLad" wrote in message
...
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

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

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

Rick


"Gary''s Student" wrote in message
...
=DATE(LEFT(A1,4),MID(A1,5,2),RIGHT(A1,2)) and format the cell as Date
--
Gary''s Student - gsnu200793


"OxonLad" wrote:

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