The DATE Function in Excel is categorized under Excel DateTime Functions. You can also calculate elapsed time. It is the main function used to calculate dates in Excel.
Supposing the ID number is shown as 7908050074059 and the first two numbers indicate birth year the third and fourth numbers are the birth day and then the following two numbers are the birth month you can use this formula.
DATEDIF Date-of-BirthTODAY y This will return completed years between two dates. Type the following formula which assumes that the first birthday is listed in cell B2. Hi the South African ID Number is 13 digits long and starts with the Date of Birth. This person is not 28 yet however the following formula takes only their birth year into consideration calculating them as 28 not 27 YEAR NOW -1900-LEFT B12 Please suggest a more accurate way of working age out.