Home>Article>Topics> What is the method for wps to extract age based on ID number?

What is the method for wps to extract age based on ID number?

藏色散人
藏色散人 Original
2019-06-13 11:04:36 19040browse

What is the method for wps to extract age based on ID number?

#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.

What is the method for wps to extract age based on ID number?

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!

Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn