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

hazuha

New Member

Join Date: Mar 2011

Location: Malaysia

Posts: 1

4th Mar 2011

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.

« Trying to add column headings to array formula | HELP!I need a specification template purchasing Interior Design it »

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are Off Forum Rules

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
social security number problem	John	Microsoft Excel Programming	6	19th May 2008 10:50 PM
How do I change a social security number to a number series?	=?Utf-8?B?TENEYXdu?=	Microsoft Excel Misc	4	22nd Dec 2005 04:15 PM
Social Security Number	montagu	Microsoft Excel Misc	3	27th Jun 2005 05:09 PM
How do I calculate age from social security number?	=?Utf-8?B?RmFpcnlmZWV0?=	Microsoft Access Database Table Design	5	27th Apr 2005 05:27 PM
How to display Social Security Number ??	Jim/Chris	Microsoft Access Forms	0	5th Aug 2003 01:55 PM