How do I calculate age using a 12 digit social security number in MS Excel?

H

hazuha

Joined
Mar 4, 2011
Messages
1
Reaction score
0
How do I calculate age for current year 2011 using a 12 digit social security number (Malaysian) where the the first six digits is DOB (yy/MM/dd). I tried Select =Left 6 digits and calling that DOB but this DOB field is not date format. If I Select =Left 2 digits, do add with 1900 and -2011 (current year) will have trouble with y2k and above birthdate, e.g. the child with birthdate 090606 (yy/mm/dd) will miscalculate for the year of 1990 instead of 2009. Can anyone help. I am using Excel 2003 compatible with 2007. Thank you very much.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I calculate age from social security number? 5
Calculate Age 2
Calculate age 3
How do I calculate age from birthdate to present in Excel? 4
How do I calculate an age from a birthdate in excel? 1
Using Year of Birth, from DOB, in later calculations 5
How do I calculate a check-digit in Excel? 5
How do I mask a Social Security Number ###-##-nnnn? 2

Top