How to extract accurate age from ID number
- 藏色散人Original
- 2020-04-13 09:50:2726196browse
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!
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：How to convert date to year month day formatNext article：How to convert date to year month day format