How to use formula to calculate age in excel Excel quick method to calculate age

王林
Release: 2024-09-02 10:37:16
Original
530 people have browsed it

How to calculate a person’s age using Excel? With the digitization of information, tables have become a common means of recording information. Calculating age is a common need when processing personnel information, but manual calculation is cumbersome and time-consuming. This summary will guide you through detailed steps to easily calculate your age using Excel formulas, making your spreadsheet work more efficient. Presented to you by php editor Baicao, please continue reading the text for detailed operation methods.

1. First open the excel office software.

excel怎么使用公式计算年龄 excel快速计算年龄方法

2. Then enter the basic date of birth information here.

excel怎么使用公式计算年龄 excel快速计算年龄方法

3. Then right-click the cell where you want to calculate age and click Format Cells.

excel怎么使用公式计算年龄 excel快速计算年龄方法

4. Then in the pop-up table, select the number and select the value, and change the decimal places to 0.

excel怎么使用公式计算年龄 excel快速计算年龄方法

5. Then enter the formula after the age: =(TODAY()-C3)/365

The c3 inside means the third in column c OK, you can change it according to your own situation.

excel怎么使用公式计算年龄 excel快速计算年龄方法

6. Finally press Enter and you will see that the age has been generated.

excel怎么使用公式计算年龄 excel快速计算年龄方法

7. Finally, use the mouse to select and then pull down to generate all age data.

excel怎么使用公式计算年龄 excel快速计算年龄方法

The above is the detailed content of How to use formula to calculate age in excel Excel quick method to calculate age. For more information, please follow other related articles on the PHP Chinese website!

source:xpwin7.com
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
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template