And more importantly, when you have a large set of data to deal with e.g. How is calculating age in excel of any help?Ĭalculating age can sometimes be tricky, particularly when you need accurate and fast results. Read this guide on how to Email Someone A Sheet Without Leaving Excel for more. Once you calculate someones age, you could send an E-Mail around so everyone knows eachothers birthdays and can celebrate together. However, it can help you have a quick rough idea of the number of months between two dates that are not too far. For instance, replace the ‘365’ in the above formula with ‘30’ to yield age in months rather than in years.ĭoing so might not return utterly flawless results as some months have 30 days, others have 31 days, and one has 28 or 29 days (during a leap year). The formula is easy to remember, and you can edit it to yield different results. This quick function can help you yield age for a large group of people with sheer ease. Pro Tip: If you want the age to be in round integers and not in decimals, use the INT function to round the age down to the nearest integer as follows. Here is how excel calculates the age against the birth date given in cell B2.ĭrag the Fill Handle to calculate the age of all the employees appearing in the list as follows. Type the above formula in the function bar as follows.ī2 consists of the birth date of the employee whose age is to be calculated. Here is a short example of how you may employ this formula to calculate ages by simply editing it in the function bar. Through this formula, excel does the same with the only difference that it goes a step ahead and also accounts for the months and days in addition to years. How would you normally calculate your age using your mind? By simply subtracting your birth year from the present year. Dividing the first part of the formula helps you yield the output in ‘years’ 365 represents the number of days in a year.Cell Reference represents the cell where you must have input the birth date.
0 Comments
Leave a Reply. |