# Dating age difference calculator

" usually implies an answer indicating how many years you have been alive.In Microsoft Excel, you can make a formula to compute an exact age in months, days, hours and even minutes.One interesting phenomenon from the rule is that the age gap widens as the person grows older.For example, the acceptable minimum and maximum dating age for a 30 year old is 22 and 46 respectively as compared to a 50 year old where it is 32 and 86 respectively.No one knows where this rule came from, but essentially it means that it is socially acceptable to date anyone who is half your age plus seven years.For example, if you are 50 years old, then the youngest acceptable age is 32.Assuming a birthdate is in cell B2, the formula to calculate age in years goes as follows: 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.

Conversely, there is a rule for the younger member in the age gap relationship that states it is acceptable to date someone who is your age minus seven years and then doubled.Dividing by the average number of days in a year works fine most of the time, but sometimes it gets the age wrong.For example, if someone was born on February 29 and today is February 28, the formula will make a person one day older.Further on in this tutorial, you will learn a couple of special functions that calculate age faultlessly regardless of the year.A more reliable way to convert DOB to age in Excel is using the YEARFRAC function that returns the fraction of the year, i.e. The syntax of the YEARFRAC function is as follows: Like in the previous example, the result of the YEARFRAC function is also a decimal number.