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.


Download Practice Workbook

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


2 Handy Ways to Calculate Current Age in Excel

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, which are very handy. 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 on a Specific Date with Formula in Excel


Similar Readings


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 functions 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: How to Calculate Age in Excel in Years and Months (5 Easy Ways)


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. Additionally, if you want to read more articles on Excel, you may visit our website, Exceldemy. If you have any questions, comments, or recommendations, kindly leave them in the comment section below.


Related Articles

Bishawajit Chakraborty

Bishawajit Chakraborty

I'm Bishawajit Chakraborty. Hello. I graduated from Rajshahi University of Engineering & Technology (RUET) with a degree in Mechanical Engineering. I'm working with ExcelDemy as a Content Developer for Excel & VBA. You can visit our website, Exceldemy if you'd like to read my published articles on MS Excel and VBA.

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo