However, this approach is not perfect either. For example, if someone was born on February 29 and today is February 28, the formula will make a person one day older.Īs an alternative, you can divide by 365.25 instead of 365 since every fourth year has 366 days. Dividing by the average number of days in a year works fine most of the time, but sometimes it gets the age wrong. To display the number of complete years, use the INT function to round a decimal down to the nearest integer:ĭrawbacks: Using this age formula in Excel produces pretty accurate results, but not flawless. In most cases, it returns a decimal number as demonstrated in the screenshot below.

The formula is obvious and easy-to-remember, however, there is a tiny problem. 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. This conventional age formula can also be used in Excel.Īssuming a birthdate is in cell B2, the formula to calculate age in years goes as follows: How do you normally figure out someone's age? Simply by subtracting the birth date from the current date. But let's be traditional, and learn how to calculate age from DOB in years first. In Microsoft Excel, you can make a formula to compute an exact age in months, days, hours and even minutes. In everyday life, the question ' How old are you?' usually implies an answer indicating how many years you have been alive. How to calculate age from date of birth in Excel Highlight ages under or over a particular age.How to create an age calculator in Excel.Get age from day, month and year in different cells.Compute when a person attains N years of age.Get age from birth date in years, months, and days.Calculate age as the number of full years.How to calculate age from date of birth in Excel.This tutorial will explain the advantages and drawbacks of each way, shows how to make a perfect age calculation formula in Excel and tweak it for solving some specific tasks.

There is no special function to calculate age in Excel, however there exist a few different ways to convert date of birth to age. You will learn a handful of formulas to calculate age as a number of complete years, get exact age in years, months and days at today's date or a particular date. The tutorial shows different ways to get age from birthday in Excel.

Microsoft excel 2011 update 14.3