calculate age from identity card number

0

How to calculate the age of a person from its identity card number on excel.

Answer
Discuss

Answers

0

Need to extract values. if your string was in cell A1 then formula would be: =DATEDIF(DATE(MID(A1,6,2),MID(A1,4,2),MID(A1,2,2)),NOW(),"Y").  1. convert string into date using Date formula. 2. use Datedif formula to take the difference between your date (from ID string) and compare it to Now.

Discuss

Answer the Question

You must create an account to use the forum. Create an Account or Login