Convert text numbers to date

[jlugo]

Hi

My sample text (which is general format when report generates) is this:

20141205 (December 5, 2014)

How can I convert that to a date so that I may drag a formula down to count # of days?
I tried dateif and datevalue and didn't work.

 

[VoG]

Try

=DATE(LEFT(A1,4),MID(A1,5,2),RIGHT(A1,2))

 

[XOR LX]

Hi.

Assuming the first part of the string is always of the precise format yymmddd followed by a space:

=0+REPLACE(REPLACE(LEFT(A1,FIND(" ",A1)),5,,"/"),8,,"/")

Edit: seeing VoG's solution it appears I may have misunderstood. I presumed that the part in parentheses was also in the cell entry, though perhaps this was just your attempt at clarification?

Regards

 

[jlugo]

YOU ARE AWESOME!!! Thanks so much.

May the universe give you abundant blessings for what you do on here!!!!!!