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" <(E-Mail Removed)> wrote in message
news1FB2161-804C-46A5-97C2-(E-Mail Removed)...
> 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" <(E-Mail Removed)> wrote in message
news:92DC4F47-178D-45C5-A3CB-(E-Mail Removed)...
> =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