Best Math Formula website. Search anything about Math Formula in this website.
how to calculate the average age in excel. It is used to calculate the arithmetic mean of a given set of arguments. Batch calculate average ages by year or month in Excel 1.
How To Calculate Age In Excel Excel Microsoft Excel Tutorial Excel Tutorials from tr.pinterest.com
TODAY -B2365 The first part of the formula TODAY -B2 returns the difference between the current date and date of birth is days and then you divide that number by 365 to get the numbers of years. The first thing you need to do is put the ages in an Excel spreadsheet. To account for a leap year occurring every 4 years 36525 is used in the formula.
This mysterious function doesnt appear in Excels Help files but it has been around since Excel 2000.
We can calculate the age in excel with the help of the TODAY function. If these were dates than excel would have suggested group by month year etc. Lets Look at an Example. If you have any doubts regarding this article or any other excel topic take it out in the comments section below.
