Community Learn Tools Library Leisure
search
English
Home > Topics > excel > 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?

藏色散人
Release： 2019-06-13 11:04:36
Original
19196 people have browsed it

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 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!

Related labels：
wps age ID number
source：php.cn
Previous article：What to do if WPS table numbers are garbled Next article：How to use table percentage calculation formula
Statement of this Website
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
Latest Articles by Author
Latest Issues
function_exists() cannot determine the custom function Function test () {return true;} if (function_exists ('test')) {echo "test is function...
From 2024-04-29 11:01:01
0
3
2270
How to display the mobile version of Google Chrome Hello teacher, how can I change Google Chrome into a mobile version?
From 2024-04-23 00:22:19
0
11
2404
The child window operates the parent window, but the output does not respond. The first two sentences are executable, but the last sentence cannot be implemented.
From 2024-04-19 15:37:47
0
1
2019
There is no output in the parent window document.onclick = function(){ window.opener.document.write('I am the output of the child ...
From 2024-04-18 23:52:34
0
1
1905
Where is the courseware about CSS mind mapping? Courseware
From 2024-04-16 10:10:18
0
0
1973
Related Topics
More>
Popular Recommendations
Popular Tutorials
More>
Related Tutorials
Popular Recommendations
Latest courses
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template