Extract Date from text

[jihaku]

We have a system that creates Transaction number base on current date,Enrolled by & enrollment number.
I want to have the Date to be automatically extracted.

Here's sample for clarification.

Transaction Number	Date Enrolled	Enrolled By	Enrollment Number
T15PU0514NZ17739	05/14/2015	TPUNZ	17739
T15PU0601NZ18203	06/01/2015	TPUNZ	18203
V15AL0127OC16110	01/27/2015	VALOC	16110
W10BA0319MB2151	03/19/2010	WBAMB	2151
W10BA0324MB2211	03/24/2010	WBAMB	2211

<tbody>
</tbody>

Coding sample:S15GE0530RM18197
First letter of the name(S),Year(15),2 letter of the name(GE),month(05),day(30),last 2 letter of the name(RM),Enrollment#(18197)


When I Type a Transaction Number,the Date will be automatically extracted from it.Is this possible & how can I do it.

Transaction Number	Date Enrolled

<tbody>
</tbody>

Appreciate your help on this.
Thanks.

 

[shobolos]

=date(mid($a2,2,2)+2000,mid($a2,6,2),mid($a2,8,2))

 

[jihaku]

Thanks for the help.