Conversion Of An Id Number To The Persons Age?

[excel in]

I'm a 1st-time user, and I would like to thank you in advance for a formula which would help in future

My question relates to a column of ID no's with total of 13 numerals eg:5807085206087
I would like to convert this to the persons age eg: 57 yrs.

The first 6 numerals describe the birthdate,the first 2 numerals 58 (1958) the 2nd two numerals are the month (07) which is July and the (08) is the day.

I have a list of 3500 and I need to insert a formula to carry out this function in Excel 2013.

Could anybody assist with a formula

Many thanks and forever indebted to you for your assistance

 

[vicedo]

Post #3 works fine.

=DATEDIF(DATE(19&LEFT(A1,2),MID(A1,3,2),MID(A1,5,2)),TODAY(),"Y")

Format the cell as a number

 

[Peter_SSs]

Format column B as General (or Number) and then re-enter the formula if it doesn't automatically adjust to the new format.

 

[jim may]

Format your cell B1 as General, then with B1 as the active cell press the F2 (edit) key, then press [Enter].

 

[excel in]

Dear Peter, I must be doing something wrong. I have formatted the ID to Number and I have pasted the formula (formatted as number) but I am still not getting 57 in column B. the formula i have pasted is([TABLE="width: 400"]
<tbody>[TR]
[TD="class: xl64, width: 400"]=DATEDIF(DATE(19&LEFT(A1,2),MID(A1,3,2),MID(A1,5,2)),TODAY(),"y")[/TD]
[/TR]
</tbody>[/TABLE]
Can u understand what I am doing wrong.
Regards
P.s I am trying everybody's input to my query but only the formula appears and not the result of 57

 

[jim may]

Under Excels OPTIONS, there is a setting that if checked tells excel to SHOW FORMULA, NOT THE RESULTS. Do you have this setting checked?

 

[Peter_SSs]

I have formatted the ID to Number ..

It isn't the ID I am suggesting to format as number or General, it is the cell/column that the formula is in, and then re-enter the formula.

If the formula still shows, then I suspect Jim's idea from post #15 may be it. To change that setting you can press Ctrl+` or, depending on your excel version, something like
File-Options-Advanced-scroll down to 'Display options for this worksheet-uncheck 'Show formulas in cells instead of their calculated results'-OK

 

[excel in]

Howdy Peter,
Thank you,I have followed all the instructions (including post #15)but alas the problem persists. I have tried the other suggested formula's (which I am very grateful ) and the result is still not showing.

 

[Peter_SSs]

Any chance then that you could upload the problem workbook to a file-share site and provide a link to that file?

 

[kalak]

Howdy Peter,
Thank you,I have followed all the instructions (including post #15)but alas the problem persists. I have tried the other suggested formula's (which I am very grateful ) and the result is still not showing.

In the formula try replacing the commas with semi-colons.

 

[excel in]

Dear Peter

Thank you and everybody else for the help.(I still have a few strands of hair left after trying everyone's input)
Once again "A BIG THANK YOU TO ALL"
The formula below worked for me
=DATEDIF(DATE(19&LEFT(T2;2);MID(T2;3;2);MID(T2;5;2));TODAY();"y")
Regards to one all