How to Calculate Current Age in Excel (2 Easy Ways)

The tutorial demonstrates various approaches for determining age in Excel given a birthdate. You will learn a few formulas to determine your exact age in years, months, and days as of this day and to compute your age as a number of full years. Excel doesn’t have a specific function for calculating age, but there are a few different ways to translate date of birth into age. This article explains the benefits and cons of each approach, demonstrates how to create an ideal age calculation formula in Excel, and discusses how to modify it to handle particular situations. This article will show you how to calculate the current age in Excel.

How to Calculate Current Age in Excel: 2 Handy Ways

Here, we will demonstrate to you how to calculate the current age in Excel by nesting the YEARFRAC and TODAY functions and combining the DATEDIF and TODAY functions. Let’s suppose we have a sample data set.

1. Nesting YEARFRAC and TODAY Functions to Calculate Current Age

In Microsoft Excel, you may get your current age by nesting the YEARFRAC function and the TODAY function.

Syntax of the YEARFRAC Function

Arguments of the YEARFRAC Function

• Birthdate: This argument represents the date of birth.
• TODAY(): This argument returns today’s date.

Step 1:

• Firstly, select the D5 cell.
• Then, write down the following formula below here.

• After that, hit ENTER.

Step 2:

• Therefore, you will see the first person’s current age in the D5 cell.
• Then, use the Fill Handle tool and drag it down from the D5 cell to the D11 cell.

Step 3:

• Finally, the given image displays the person’s current age.

Read More: How to Calculate Age in Excel in dd/mm/yyyy

2. Combining DATEDIF and TODAY Functions to Calculate Current Age

If you want to know a person’s actual age, you can find out how many years, months, and days have passed since their birth. The DATEDIF function should be combined into a single formula as shown below in step 1.

Syntax of the YEARFRAC Function

Arguments of the YEARFRAC Function

• Start_date: This date signifies the period’s starting date value. It may be entered as serial numbers, text strings included in double quotes, or the output of another function, such as DATE ().
• End_date: This date signifies the period’s end date value. It may be entered as serial numbers, text strings included in double quotes, or the output of another function, such as DATE ().
• Unit: What kind of result you get from this function will depend on this unit. Depending on the unit you use, the DATEDIF function can produce one of six alternative outputs. The available units are listed below:
• “Y” indicates how many of the requested years have already passed.
• “M” indicates how many of the required number of months have been completed.
• “D” indicates how many of the days in the given timeframe were completed.
• “MD” – returns the number of days in the period but ignores days that have already passed in the Years and Months.
• “YM” returns the total number of months in the period but ignores months in already-completed years.
• “YD” – yields the total number of days in the period but ignores days in already-completed years.

Step 1:

• Firstly, choose the D5 cell.
• Secondly, type the following formula below here.

• Then, press ENTER.

Step 2:

• Here, you will find the first person’s current age in the D5 cell.
• After that, drag the Fill Handle tool from the D5 cell to the D11 cell.

Step 3:

• Lastly, you will see all the person’s current ages in the given image here.

Read More:  Excel VBA: Calculate Age from Date of Birth

Download Practice Workbook

You may download the following Excel workbook for better understanding and practice it by yourself.

Conclusion

In this article, I’ve covered 2 handy ways to calculate the current age in Excel. I sincerely hope you enjoyed and learned a lot from this article. If you have any questions, comments, or recommendations, kindly leave them in the comment section below.

Related Articles

<< Go Back to Calculate Age | Date-Time in Excel | Learn Excel