Formula for age dating

In most cases, it returns a decimal number as demonstrated in the screenshot below.

To display the number of complete years, use the INT function to round a decimal down to the nearest integer: Drawbacks: Using this age formula in Excel produces pretty accurate results, but not flawless.

In some situations, however, you may need something very specific.

This formula comes in handy in situations when the complete date to calculate at is not defined, and you know only the year.

Let's say you are working with a medical database, and your goal is to find out the patients' age at the time they underwent the last full medical examination.

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.

The formula is obvious and easy-to-remember, however, there is a tiny problem.

Leave a Reply