+ Reply to Thread
Results 1 to 14 of 14

Autocalculate Age from Identity Card Number

Hybrid View

  1. #1
    Forum Guru (RIP) Marcol's Avatar
    Join Date
    12-23-2009
    Location
    Fife, Scotland
    MS-Off Ver
    Excel '97 & 2003/7
    Posts
    7,216

    Re: Autocalculate Age from Identity Card Number

    Aye, the forum has been crashing on me all day, it's hard to keep up.
    I noticed that you posted one reply twice, did you get a warning about "Navigating away from the page" when you first tried to post?

    This workbook has your formula corrected for the record, and a possible minimum age (5) for holding an ID card solution.
    I realise that this doesn't give the result that the OP asks for but it covers an age group from 5 to 104.

    Just a thought.


    [EDIT]
    This post crashed, but sent the text without the attachment ...
    Attached Files Attached Files
    Last edited by Marcol; 01-04-2012 at 08:54 AM.
    If you need any more information, please feel free to ask.

    However,If this takes care of your needs, please select Thread Tools from menu above and set this topic to SOLVED. It helps everybody! ....

    Also
    اس کی مدد کرتا ہے اگر
    شکریہ کہنے کے لئے سٹار کلک کریں
    If you are satisfied by any members response to your problem please consider using the small Star icon bottom left of their post to show your appreciation.

  2. #2
    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