Wednesday, August 22, 2012

Extract Birthdate from Malaysia IC No

You can extract the birthday from the Malaysian IC No using the formulas as shown below:




You may need to check your Microsoft Windows date format settings to make sure the date format is set as d/m/yyyy.

If you set as m/d/yyyy, then you have to change the arrangement in B8 as B5&"/"&B6&"/19"&B4.

4 comments:

  1. I had been looking around the best blogs site and now I’m on the right place, pretty wonderful!! advance payday loan

    ReplyDelete
  2. this is the best, yearggggggh, finally im found how to get the birthday month from IC list.

    TQ

    ReplyDelete
    Replies
    1. Glad you found it and like it. Let me know of other functions you need.

      Delete
    2. Hi, I have trouble for IC for those born on 2000 onwards

      Delete