#What is the method and formula for wps to extract age based on ID number?
The 7th to 14th digits of the ID number represent: year, month, and day of birth.
As shown in the above illustration, enter the ID number in column A.
Method to extract birthday: B2=TEXT(MID(A2,7,8),"0-00-00")
Method to extract age: C2=DATEDIF(TEXT(MID (A2,7,8),"0-00-00"),TODAY(),"y")
For more Excel-related tutorials, please visit theExcel Basic Tutorialcolumn!
The above is the detailed content of What is the method for wps to extract age based on ID number?. For more information, please follow other related articles on the PHP Chinese website!