How do you calculate the age, something, and actual ages in Excel?

In Excel, using system time and birth date to calculate age, something age and the actual age, in the personnel management, payroll statistics frequently encountered, the following is to introduce the method of calculating the age problem (in Excel2003, for example, the other version is similar).

Steps:

Years of age calculation (method i):

Enter the formula =year (today ())-year (B2) in cell C2 (as shown in the following illustration). Then enter the C2 cell to complete the age of the year, and then double-click the lower right corner of the cell to fill or drag the lower right corner of the cell to fill down.

Years of age calculation (Method II):

Enter the formula "=int (today ()-b2)/365" in cell D2 (as shown in the following illustration), then enter the D2 cell to complete the age of the year, and then double-click the lower right corner of the cell to fill or drag the lower right corner of the cell to fill down.

Something calculation:

The age of the formula based on 1 can be added. In the E2 cell, enter the formula "=int ((Today ()-b2)/365) +1" (as shown in the following illustration) or "=year (today ())-year (B2) +1", and then enter, E2 cell to complete the age of the year of the calculation, Then double-click the lower-right corner of the cell to fill or drag the lower-right corner of the cell to fill it down.

Actual Age Calculation:

Enter a formula in cell F2 =year (today ())-year (B2) & "old" &month (today ())-month (B2) & "Month" &day (today ())-day (B2) & "Day" (as shown in the following image), and then enter, F2 the age of the year in the cell, and then double-click the lower-right corner of the cell to fill or drag the lower-right corner of the cell to fill it down.

The final effect:

Now look at the effects of the age, something, and actual ages (as shown in the figure below).

The above is in Excel How to calculate the year old, something and the actual age method introduction, the operation is very simple, everybody according to the above steps carries on the operation, hoped can have the help to everybody!