Results 1 to 3 of 3

Extract ID to DOB & Age for year 2000 and above

Threaded View

  1. #1
    Forum Contributor
    Join Date
    05-10-2019
    Location
    Penang, Malaysia
    MS-Off Ver
    2016
    Posts
    262

    Extract ID to DOB & Age for year 2000 and above

    Hi All,

    The country where I am from has the ID which is the first 6 digits determined our year, month, day. eg, 050101 (2005-Jan-01). I have no issue for those who were born below 2000 but above the formula doesn't work.

    How to make both DOB & Age works regardless of what year they were born?

    Please find attachment.

    Thank-You very much
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Match serial date (year) to number list 2000
    By JO505 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 01-20-2015, 05:42 PM
  2. Match serial date (year) to number list 2000
    By JO505 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-20-2015, 02:08 PM
  3. Selecting the 10 % best performing stocks each year from 2000- 2012
    By Norwegian in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-18-2013, 08:41 AM
  4. Intro - xl/access since year 2000 - a Systems Analyst by trade
    By tweedle in forum Hello..Introduce yourself
    Replies: 1
    Last Post: 08-13-2012, 05:34 AM
  5. Extract spesific line from more then 2000 txt files!
    By dwloko32 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-08-2011, 06:09 PM
  6. VBA to convert 1930-1999 year format to year 2000 format
    By maacmaac in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 11-09-2011, 04:54 PM
  7. In Excell-2000, database how do you extract unique records
    By bgpereira in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 12-24-2005, 02:50 AM

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