Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I calculate the age of a person from their ID no.?
I have a work sheet which provides the ID number of a person (the first 6
digits are the birth date of the person YYMMDD). Another column requests age. How can I create a formula that will automatically calculate the age of the person as at the current date? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I calculate the age of a person from their ID no.?
On Fri, 29 May 2009 04:18:01 -0700, Tracey
wrote: I have a work sheet which provides the ID number of a person (the first 6 digits are the birth date of the person YYMMDD). Another column requests age. How can I create a formula that will automatically calculate the age of the person as at the current date? Ah, your question brings to mind the Year 2000 problem, which was due in part to the custom of using only two digits to specify a year. If no one was born in this century, then: =DATEDIF(DATE(LEFT(A1,2),MID(A1,3,2),MID(A1,5,2)), TODAY(),"y") But that may only be true for an unknown number of years, so you are going to have to supply the possible age range for your persons in order to devise a formula that will continue to work for the foreseeable future, or change your ID's to use four digit years. --ron |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to calculate age of a person? | New Users to Excel | |||
how do I calculate the age of a person | Excel Worksheet Functions | |||
Calculate needed gallons of water, based on weight of person | Excel Worksheet Functions | |||
How do I calculate the age of a person? | New Users to Excel |