How to extract accurate age from ID number

How to extract the exact age from the ID number

Make an Excel with the ID number and add the identity Put the certificate number in column A;

Recommended: "Excel Tutorial"

Enter the age in column B: =DATEDIF( TEXT(MID(A1,7,8),"#-00-00"),TODAY(),"Y")

Then mark "√" to get the first ID number Age;

Pull down the small solid icon;

to get the age with an ID card.

The above is the detailed content of How to extract accurate age from ID number. For more information, please follow other related articles on the PHP Chinese website!