What is the method for wps to extract age based on ID number?
- 藏色散人Original
- 2019-06-13 11:04:3619195browse
#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 the Excel Basic Tutorial column!
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
Previous article：What to do if WPS table numbers are garbledNext article：What to do if WPS table numbers are garbled