Change my stock code to date?

[kliff]

I've set my stock codes using this format: year, month represented by a letter, stock descriptions.
For eg. 11B***** means year 2011, with 'B' designated for the month of February.
I already have the formula to calculate the number of months between 2 dates. I need to convert my stock codes to a date format.
How do I convert the first three numbers/letter to a date format so that I can use a formula to tell me how many months have past.

Thanks.

 

[Armando Montes]

Try this:
=DATE(LEFT(A2,2)+2000,CODE(RIGHT(A2,1))-64,1)

 

[kliff]

Thanks, Armando.
Could you help me tweat a bit more?
For eg, 10B05BX21
fisrt two digits mean 2010
the letter designates the month. ([FONT=Arial, sans-serif]A=Jan, B=Feb, C Mar, D Apr, E May, F Jun, G July, H Aug, J Sep, K Oct, L Nov, M Dec)
Is there any way I can have a formula to detect all these codes?
Or it's easier for me to add a new column with just the month?
[/FONT]

 

[Armando Montes]

Like this?
=DATE(LEFT(A2,2)+2000,CODE(MID(A2,3,1))-64,1)

 

[kliff]

Yes, yes, Armando. That's almost what I want.

The thing is I don't have an 'i' in the code.
The formula works fine for the months from Jan through Aug.
But from September onwards, I need to minus a value of one since the code for September is "J" instead of "i",
Oct is "K'" instead of "j",
Nov is "L"
Dec is "M".

thanks, Armando, for what you've done so far. Really appreciate it.

 

[Armando Montes]

Try this:
=DATE(LEFT(A1,2)+2000,CODE(MID(A1,3,1))-64-(MID(A1,3,1)>"H"),1)

 

[kliff]

Perfect, Armando!
You're brilliant.
I'd have used a complicated IF ELSE condition.
You've made my job easier.
Thanks a million.