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

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.

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

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

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

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.

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

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

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!