Excel에서 나이를 계산하는 방법

In this process, we will guide you through the steps to calculate age using Excel.

This involves entering a specific formula into the desired cell, allowing the automatic calculation of age based on the provided data.

There are a few ways to calculate someone’s age in Excel, depending on how accurate you want the result to be. Here are the most common methods, explained simply:

1. Using YEARFRAC and INT (more accurate)
If you want an accurate age calculation that accounts for leap years and partial years, this is a great option.

Formula:
=INT(YEARFRAC(date_of_birth, TODAY()))

• Replace date_of_birth with the cell containing the person’s birthdate.

• TODAY() gets the current date automatically.

• YEARFRAC calculates the total number of years (including decimals) between two dates.

• INT removes the decimal part to give the full number of years.

2. Using YEAR and TODAY (quick and simple)
This method is easier but may be off by a year if the birthday hasn’t occurred yet this year.

Formula:
=YEAR(TODAY()) - YEAR(date_of_birth)

• It just subtracts the birth year from the current year.

• It doesn’t account for whether the birthday has already passed, so it’s not always precise.

3. Using DATEDIF (less common but accurate)
Another accurate way is with the DATEDIF function, which isn’t listed in Excel’s suggestions but works reliably.

Formula:
=DATEDIF(date_of_birth, TODAY(), "y")

• This calculates the number of full years between the birthdate and today.

• It’s accurate and simple once you know the formula.

Step-by-Step Guide: How To Calculate Age In Excel

Step 1

Select the cell where you want the age to be displayed.

Step 2

Click on that cell and enter the following formula: =TRUNC(YEARFRAC(<start_date>, TODAY(), 1)). Refer to the video for a detailed walkthrough.

Step 3

Once done, press "Enter." This will automatically calculate and display the ages in the selected cell.