There are certain activities in Excel that are often performed while working with spreadsheets, and in this case there is a need to automate them where possible to increase the productivity of the jobs performed.
An example of this is the age calculation in Excel. And for those who work with people records or even calculations of days, it is necessary to optimize this operation in order to avoid that the whole manual process is done besides avoiding possible errors. Thinking through this subject, we separate a step by step so you can learn how to calculate age in Excel in a practical and efficient way. Follow us!
Knowing the functions
The calculation of ages may be simple for some people, but have you ever imagined having a spreadsheet with users' records with their respective dates of birth and their ages? In this case, there will be work on having to update the dates daily as people pass anniversaries over the days.
However, to avoid all this work and automate this task, it is enough to make use of two simple functions, being INT and NOW.
This function basically weights a number.
Syntax: INT (num)
On one: represents the number or reference of a cell to be rounded.
The NOW function is intended to display the current time and date (depending on the cell format), which is very useful when you want to perform calculations with dates and is recalculated automatically whenever the worksheet is reopened.
Syntax: NOW ()
Now that we know the details of the functions that will integrate the calculation of age, follow below a practical example where there is a table with dates of birth, current date and a column that will receive the calculation of the age.
In the "Current Date" column we will use the AGORA () function to insert the current date and update it whenever we open the worksheet in the later days.
At the end of the function just hit enter and check the result.
To apply the same function to the other cells, simply use the fill handle.
In the next step, we will use the INT function to calculate the difference between the date of birth and the current date. In this way, we will have an integer value that represents the age. See below:
Note that we are performing a subtraction of the current date with the date of birth in which it will bring an integer value. This result will be divided by 365,25 due to leap years.
At the end of the operation, just hit enter and check the result.
To replicate the function to the other cells, we will use the auto-fill handle again
We can also test the automatic updating of the ages, for example by changing a date of birth.
In this way, we have a calculation of dates always updated according to the dates and without the need to carry it out frequently.
Based on the tips mentioned here, it was possible to know the step by step to perform the automatic calculation of ages. Therefore, with the use of this feature it is possible to optimize this calculation by having the integration of an automatic function.
Did you like the tip? Check out other Excel tips at Our site!