![]() The result will be the person's age in years.In a third cell, use the formula =INT((TODAY()-A1)/365.25) where A1 is the cell containing the birthdate.Enter the birthdate in one cell and the current date in another cell.Steps to calculate age using this method: ![]() This can be done using a simple formula that subtracts the earlier date from the later date, and then divides the result by 365.25 to account for leap years. ![]() One way to calculate the number of years between two dates in Excel is to simply subtract the birthdate from the current date.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |