How to automatically calculate age in excel
- 王林Original
- 2019-12-20 16:36:1325670browse
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!