Convert number to Date value

[krunk]

How can i convert this string of numbers, which is a date 20120102 into TRUE date string because i am trying to find day of week? i tried a text formula but it didn't work.

Appreciate your help once again.. lifesaver.

[Pete_UK]

Use this:

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

then format as date. I've assumed your number represents yyyymmdd - if the month and date are reversed, then change the 2nd and 3rd terms around in the formula above.

Hope this helps.

Peete

[krunk]

Thank you! I don't know why i didn't think of this combo.