Excel age calculation formula
Or open the Excel table to edit and select "Age column"; Right-click the select format cell, select a number from the number option, select 0 as the decimal place, and then click OK. Navigate to the next cell of "Age" in the table, enter "= (Today () -D2)/365" and press Enter; Re-select this cell, move it to the lower right corner, and when the cursor becomes a black cross, "double-click" to calculate everyone's age.
Excel generally refers to Microsoft Office Excel, which is a spreadsheet software written by Microsoft for computers using Windows and Apple Macintosh operating systems. Intuitive interface, excellent calculation function and chart tools, coupled with successful marketing, make Excel the most popular personal computer data processing software.