Formula for Date from text

[gautamacharya]

Hi,
I have a text filed that has Serial Numbers like "EBT0817J434" the 08 is the year and the 17 is the week of the year. I need the formula to return in a dd/mm/yyyy format. I have a formula (someone in this forum had helped me ) to extract the mm/yyyy from the same field but it did not extract the day. Below is that formula. If you can add the beginning of the week for the day to this formula, then great.

=(IF(LEN(A1)=11,(DATEVALUE(MONTH(DATE("20"&LEFT(MID(A1,4,4),2),1,1)+RIGHT(MID(A1,4,4),2)*7)&"/"&YEAR(DATE("20"&LEFT(MID(A1,4,4),2),1,1)+RIGHT(MID(A1,4,4),2)*7))),"N/A"))

Thanks
Gautam