How do I calculate age from two dates in Excel?

Simply by subtracting the birth date from the current date. This conventional age formula can also be used in Excel. 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.

How can I calculate age difference in Excel?

How to calculate age in ExcelIn the third cell, for us its C2, enter the following formula: =DATEDIF(A2, B2, “y”). You can also get a persons age without entering todays date in the second cell. The final, most specific measurement that you can make is a persons age, including months and days.More items

How many years apart can you date?

Federal law makes it criminal to engage in a sexual act with another person who is between the age of 12 and 16 if they are at least four years younger than you. Each state takes a different approach as the age of consent has ranged from 10 to 18.