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.
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. 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. The datedif function may calculate incorrect results under certain scenarios Please see the known issues section of this article for further details. How to change the date of birth varies depending on the current listed age and local laws requiring parental or guardian consent
Dates should be entered by using the date function, or as results of other formulas or functions For example, use date (2018,5,23) for the 23rd day of may, 2018 Problems can occur if dates are entered as text. For under 19s, adult consent is also required for gaming. Learn about age limits and how to control access to microsoft copilot. Why am i required to provide consent even though i am above statutory age
The birthdate on your account indicates that you're underage Use our interactive tool to help guide you to the right steps to correct it.
OPEN
