+ Reply to Thread
Results 1 to 14 of 14

Autocalculate Age from Identity Card Number

Hybrid View

  1. #1
    Registered User
    Join Date
    01-04-2012
    Location
    Malaysia
    MS-Off Ver
    Excel 2007/10
    Posts
    6

    Re: Autocalculate Age from Identity Card Number

    My 1st uploaded file might be with wrong formula to calculate the age that's why it return for 101 age instead of 1 year old of age. It should return as 1 year old of age.
    There is no minimum age in here (Malaysia) to make Identity Card Number.
    Rarely people lives more than 100 years of age in here.
    e.g. 110106105717 means the birth date 06/01/2011 (1st 6 numbers) rarely to see people born on the year 1911 with ID number anymore.
    Thank you everybody for your help.
    I must add in the DOB next to Identity Card Number and to get the actual Age (Below 100 years old).
    Thanks again
    Last edited by suriawati; 01-04-2012 at 11:18 PM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1