Retrieve date value from text string and format as a date

Can someone help?

I need to format a date in column 'B' as mm/dd/yyyy. Currently April 9 2015 is displayed as 040915 but I need it to be displayed as 4/9/2015. The formula in column 'B' is

=IFERROR(IF(DATE(2000+RIGHT(RIGHT(L2,6),2),LEFT(RIGHT(L2,6),2),MID(RIGHT(L2,6),3,2)),RIGHT(L2,6),""),"")

this formula pulls last six digits from a text & number string in column 'L'. the sample data and a screenshot are attached below.

I tried to embed DATEVALUE function in the formula in this column but Excel doesn't recognize this as a date and returns #VALUE error. I also tried to format the values as a dates but nothing works.

the formula works as a charm! Thanks so much! I added reputation to your profile.