Dividing 17807 with 365 results in the number of years, 48.78 in this case. Therefore, we can use the following Basic Formula to Calculate Age in Excel, =(Todays Date Date of Birth) / 365. By providing different entities, you . 2. We can change the time in the dataset with the original Current Time. This common formula for calculating age can also be utilized in Excel. It can be either years or months or days. Excel can automatically calculate and display the age based on the date of birth. Thank you for reading this article, we hope this was helpful. 6. How do i calculate month and year in excel? Repeatedly, we need to use the Fill Handle to find the age in the other cells. In this article, we have tried to discuss all the functions which are used to find ages. (TODAY ()-B2) refers to the difference between the birthdate and current date, and /365 . 5. = (TODAY ()-B2)/365 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. For showing the age in complete years, use the, Instantly, the Microsoft Visual Basic for Applications window opens. Read More: How to Calculate Average Age in Excel (7 Easy Methods). Here, Office Tab supports similar processing, which allow you to browse multiple Excel workbooks orWord documents in one Excel window or Word window, and easily switch between them by clicking their tabs. We will Calculate Age in Excel using the CONCATENATE function and DATEDIF in Years, Months, and Days. First, open up your Excel sheet and locate the cells where you want to calculate age.