Current location - Recipe Complete Network - Healthy recipes - ID card age calculation formula
ID card age calculation formula
The formula for calculating the age of ID number is = year (now ())-mid (C3,7,4).

If you want to get the age of the first ID number, you should enter = year (today ())-mid (a2,7,4) and click Enter, so that we can get the age of the first ID number.

The specific operation method is as follows:

1. Open the Excel document to be operated.

2. Enter year-(today)-mid (A2) in the cell for which you want to calculate the age (A2 is the cell with the id number). 3. After entering the calculation formula,-Enter,-Calculate the age.

4. Age of other rows-drag cells with age-to get the age.

In personnel work, it is often necessary to process the employee's ID card information. How to quickly calculate the age from the ID number?

Only calculate the age by year.

The following figure shows the employee's ID card information (data simulation, the last four digits have no influence on the case, all of which are shown as X).