contador web Skip to content

How to calculate age in Excel | Productivity

Excel offers features for making automatic age calculations, useful for those who need to find out how old people are from a large database. The account can be made considering the period between two dates here, we will use the date of the day the spreadsheet was made and the date of birth. It is noteworthy that the formula used in the step by step is not only for age, but can be used to identify any time interval. Check out in the following tutorial how to calculate the age of a large volume of people automatically by Excel.

How to make pie chart in Excel

How to create charts in Microsoft Excel

How to create charts in Microsoft Excel

Want to buy a cell phone, TV and other discounted products? Meet the Compare TechTudo

Step 1. In the Excel spreadsheet, create a column programmed with the formula TODAY to automatically update the current date in future operations. To do this, select the cell and type the formula = TODAY (), displaying the date as soon as activated with the Enter key;

Create a column for the current date and enter the formula = TODAY () Photo: Reproduction / Daniel RibeiroCreate a column for the current date and enter the formula = TODAY () Photo: Reproduction / Daniel Ribeiro

Create a column for the current date and enter the formula = TODAY () Photo: Reproduction / Daniel Ribeiro

Step 2. Then replicate the programmed command to the other rows of this column. Click on the dot in the lower right corner of the cell with the formula TODAY and drag it down to the desired limit;

Drag the dot in the lower right corner of the cell with the formula to replicate the schedule. Photo: Playback / Daniel RibeiroDrag the dot in the lower right corner of the cell with the formula to replicate the schedule. Photo: Playback / Daniel Ribeiro

Drag the dot in the lower right corner of the cell with the formula to replicate the schedule. Photo: Playback / Daniel Ribeiro

Step 3. To create the schedule that calculates dates, I need to specify three variables of the formula. DATAIF: the start date, current date, and calculation unit (which may be in full years, yfull months m, or days, d). In this case, the formula = DATADIF (B2; C2; y) was used, with B2 and C2 indicating the cells in the start and current date columns, respectively, while y specified the response in number of years;

Enter the formula = DATADIF (B2; C2; y) to calculate the age, with B2 and C2 the start and current dates and y the age in years Photo: Reproduction / Daniel RibeiroEnter the formula = DATADIF (B2; C2; y) to calculate the age, with B2 and C2 the start and current dates and y the age in years Photo: Reproduction / Daniel Ribeiro

Enter the formula = DATADIF (B2; C2; y) to calculate the age, with B2 and C2 the start and current dates and y the age in years Photo: Reproduction / Daniel Ribeiro

Step 4. To reproduce the formula in the lines below, left-click on the dot in the lower right corner of the cell with the DATADIF formula and drag it to the desired line;

Reproduce the formula by dragging the dot in the bottom corner of the cell Photo: Reproduction / Daniel RibeiroReproduce the formula by dragging the dot in the bottom corner of the cell Photo: Reproduction / Daniel Ribeiro

Reproduce the formula by dragging the dot in the bottom corner of the cell Photo: Reproduction / Daniel Ribeiro

Step 5. It is possible to combine the response of the DATADIF formula with other variables, among them the other three more sophisticated: difference of days, ignoring years and months, md, difference of months, ignoring days and years, ym or difference in days, ignoring years yd. To do this, remember to enter & to specify response parameters and new formulas;

  It is possible to sophisticate the count in years, months and days by combining the DATADIF formula with itself, but with other response parameters. Photo: Reproduction / Daniel Ribeiro  It is possible to sophisticate the count in years, months and days by combining the DATADIF formula with itself, but with other response parameters. Photo: Reproduction / Daniel Ribeiro

It is possible to sophisticate the count in years, months and days by combining the DATADIF formula with itself, but with other response parameters. Photo: Reproduction / Daniel Ribeiro

How to count values ​​in alternate cells in Excel? Find out on the TechTudo Forum.