Excel can help you calculate the age of a person in different ways. Calculate age in accumulated years, months, and days You can also calculate age or someone’s time of service The result can be something like “2 years, 4 months, 5 days.” 1 Use datedif to find the total years In this example, the start date is in cell d17, and the end date is in e17.
The datedif function may calculate incorrect results under certain scenarios Please see the known issues section of this article for further details. Whether you're setting up a new account or updating an existing one, you'll find answers here about verification methods, accepted forms of id, and what features may be restricted if your age isn't confirmed. Use date and time functions to create formulas that return serial numbers, display a specific date or time, or that calculate the difference between dates or times. How to change the date of birth varies depending on the current listed age and local laws requiring parental or guardian consent Expand a section below to learn more, depending on your age or error message.
For example, use date (2018,5,23) for the 23rd day of may, 2018 Problems can occur if dates are entered as text. When you verified your identity using the pass authentication system, we received a birth date that doesn’t match the birth date for your microsoft account This means that you’ll need to update your birth date for your microsoft account before you can sign in and play games. For under 19s, adult consent is also required for gaming.
WATCH
