Skip to content

How to Calculate Your Age in Excel

Here is a common question. You have your birthdate and today’s date, and all you want to know is how to calculate your age using Excel.

In this article, I will show you how to do just that.

Calculate Your Age Using YEARFRAC

The easiest way to calculate your age in Excel is to use the YEARFRAC function. This function calculates the number of years between a start date and an end date.

To use this function to calculate your age, start by listing your birthdate and the current date within your spreadsheet.

Next, pick a cell you want to use for calculating your age and enter the following formula.

=YEARFRAC(startDate, endDate)

The formula will then calculate the years between the two dates giving you your age. In this example, the user is 30.67 years old.

How to Get Rid of the Decimal

Let’s say you do not want the decimal part of this number. For instance, instead of 30.67, you just want 30.

To get rid of the decimal and always round down, nest the YEARFRAC function inside of the ROUNDDOWN function like so.

=ROUNDDOWN(YEARFRAC(startDate, endDate), 0)

The ROUNDDOWN function takes the result from the YEARFRAC function and rounds that number down to the nearest whole number due to the zero specified as the second argument for the ROUNDDOWN function.

And that is the easiest and most effective way to calculate your age in Excel.

This Post Has 2 Comments

    1. Hi Meagan!

      Yes. There are actually a few methods you could use. One method would be to take your age in decimal form and then subtract the rounded version leaving you will only the decimal part.

      You can then take the decimal value and multiply it by 365 to give you the number of days. That way, you end up with the number of years and then the number of days.

      From the example in the article…

      30.67- 30.00 = 0.67
      0.67 * 365 = 244.55

      So you can infer that you would be 30 years and about 245 days old.

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Back To Top