How to calculate age in excel and how to calculate age in excel?

The XCEL calculation of age generally uses the system time and the date of birth to calculate the age. Excel calculation age is used frequently in personnel management and salary statistics, and the relevant Excel calculation age is introduced as follows:

Tip: The rules for calculating length of service are not the same. Some are calculated on the basis of "virtual length of service", for example, the length of service from June 1, 1998 to December 31, 2000 is 3 years; In some cases, the length of service from 1 June 1998 to 31 December 2000 was two years.

For similar problems, you can use the ceiling function or trunc function to deal with similar problems.

Excel calculates age.

Excel Calculation Age Method 1:

Real age:=trunc((days360(a2,today()) 360,0)

Virtual age:=ceiling((days360(a2,today()) 360,1)

Excel Calculation of Age Method 2:

right(year(today()-a2),2)

Excel Calculation of Age Method 3:

int((today()-a2)/365)

int((n(today()-a2))/365)

Excel Calculation Age Method IV:

int(days360(a2,today(),/360)

Excel Calculation Age Method 5:

text(today()-a2,"y")

Excel Calculation Age Method 6:

int(yearfrac(date(2011,11,5),a2,1))

excel method for calculating age seven:

year(today())year(a2)

Excel Calculation Age Method 8:

datedif(a2,today(),"y")

Moreover, it is often necessary to use formulas to calculate age in Excel, and how to calculate formulas using formulas is described in detail as follows:

Open the Excel you want.

Select the age column.

Press the right mouse button and select "Format Cells".

In Number Options, select Numeric Type, select 0 for the number of decimal places, and click OK.

Navigate to cell E2.

Enter "=(today()-d2) 365" (enter quotation marks, excluding quotation marks).

Re-select the cell.

Move the cursor to the bottom right corner of the cell, and when the cursor changes to a black cross, double-click.

How to calculate age in Excel.

Here's how:Material Tools: Excel2010

1. Open the excel document you want to operate.

2. Enter year(today()mid(a2,7,4) in the cell where you want to calculate the age, where a2 is the cell of the ID number.

3. After entering the calculation formula, press the enter key to calculate the age.

4. For the age of other rows, drag the cell that already has the age to get the age.

Excel uses the old certificate of the body.

The current year can be obtained by year, today, and the year of birth of the ID card can be obtained by using the mid function, and the age can be obtained by subtracting the two. The steps are as follows: 1. Open the excel** that needs to be operated, and enter :

year(tody())mid(), and then click to select the cell where the ID number is located. 2. Continue to enter 7 and 4 in the formula box) and press enter to complete the input of the formula. 3. Return to excel**, and you can find that the age has been successfully calculated by the ID number.

Structure and form.

1 The structure of the number, the citizenship number.

It is a feature combination code, which consists of a seventeen-digit ontology code and a check code. The order from left to right is: six-digit address code, eight-digit date of birth code, three-digit sequential code and one-digit check digit.

2.The date of birth code indicates the year, month and day of birth of the encoded object, which shall be implemented in accordance with the provisions of GB T7408, and there is no separator between the year, month and day**.

3 Sequence code, which represents the sequence number assigned to a person born in the same year, month and day within the area identified by the same address code, with the odd number of the sequence code assigned to the male and the even number assigned to the female. 4. Check code, according to the first seventeen digits of the code, according to ISO 7064:**mod 11-2 check size check code calculated by the check code.

Enter the date of birth in A2 and the formula in B2: =DateDiF(A2,Today(),Y")

You can calculate the number of acres of age as of today's selling wheel. (Such as pants with Mori below).

Straight and vertical calculation:

datedif(substitute("","Missing,"-date(2019,1,1),"y")

If in cell A1, then:

datedif(substitute(a1,".date(2019,1,1),"y")

The expiration date formula date(2019,1,1), if you start the large cell date format, you can drink the cell directly.

It depends on whether you are calculating the scum through the ID card and whether the date of birth has been filled in.

The above should be extracted through Nasun, and the year of birth will be subtracted from this year.

1. First of all, include some basic information about the employee, including the date of birth.

2. Then, in the cell that you want to display the age in the bridge book, write the function =year(today()) which represents today's date.

3. The second step is to write the second part of the company and write the function "year(c2)". This is minus the date of birth.

4. After entering the company, click "Enter", and you can see the age display below.

5. The calculation results of the ages of all employees are shown in the figure below. Of course, this method can also be used to calculate the length of service of an employee. Change the date of birth to the date of entry.

6. Of course, we can also more accurately confirm the number of days these employees have been employed.

7. Click "Enter" to view the calculation result.