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

Get FREE Advanced Excel Exercises with Solutions!

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.

 Handy Ways to Calculate Current Age in Excel


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

=YEARFRAC(birthdate, TODAY())

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.
=YEARFRAC(C5,TODAY())
  • After that, hit ENTER.

 Nesting YEARFRAC and TODAY Functions to Calculate Current Age in Excel

Formula Breakdown

  • TODAY(): This function returns today’s date.
  • =YEARFRAC(C5,TODAY()): This final combined function represents the current age in the following data set.

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

=DATEDIF(start_date, end_date, unit)

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.
=DATEDIF(C5,TODAY(),"Y") & " Years, " & DATEDIF(C5,TODAY(),"YM") & " Months, " & DATEDIF(C5,TODAY(),"MD") & " Days"
  • Then, press ENTER.

 Combining DATEDIF and TODAY Functions to Calculate the Current Age in Excel

Formula Breakdown

  • DATEDIF(C5,TODAY(),”Y”): This function shows the exact number of years.
  • DATEDIF(C5,TODAY(),”YM”): This function represents the number of months.
  • DATEDIF(C5,TODAY(),”MD”): This function demonstrates the number of days.
  • =DATEDIF(C5,TODAY(),”Y”) & ” Years, ” & DATEDIF(C5,TODAY(),”YM”) & ” Months, ” & DATEDIF(C5,TODAY(),”MD”) & ” Days”: This final function shows the exact current age including years, months, and days of any person.

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

What is ExcelDemy?

ExcelDemy - Learn Excel & Get Excel Solutions Center provides online Excel training , Excel consultancy services , free Excel tutorials, free support , and free Excel Templates for Excel professionals and businesses. Feel free to contact us with your Excel problems.
Bishawajit Chakraborty
Bishawajit Chakraborty

Bishawajit Chakraborty, a Rajshahi University of Engineering & Technology graduate with a B.Sc. in Mechanical Engineering, has been associated with ExcelDemy since 2022. Presently, he is a content developer, specializing in Excel Power Query, Data Analysis and VBA. It is worth mentioning that he has authored more than 90 articles on VBA content development. His profound interest lies in the fields of data analytics and data science. He possesses expertise in VBA, Power BI, machine learning, and Python... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo