How to automatically calculate age in excel

Enter basic information in the form, such as name and date of birth

Calculating age one by one is too troublesome and a waste of time. We can easily generate age by just inserting a function formula. The first step is to select the age column with the mouse and set the cell table format

In the pop-up dialog box, select "Number", select "Value" and change the number of decimal places to 0, click Confirm

The second step is to select the first person with the mouse (Cui Ming) For the age table at the end, enter =(TODAY()-C3)/365. C3 in the formula stands for "column C, row 3". Modify according to the column and row of the date of birth

The second step is to click the Enter key to confirm. After confirmation, you will find that the age has been automatically generated

The third step is to use the mouse to select the drop-down and all will be automatically generated, which can improve work efficiency

Recommended related articles and tutorials: excel tutorial

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