How to Convert Date of Birth to Age in Excel (3 Easy Ways)

Get FREE Advanced Excel Exercises with Solutions!

While working in an excel spreadsheet, sometimes we need to convert the date of birth to age. To know any person’s age, we can use some simple methods in Excel. In this article, I will show how to convert date of birth to age in Excel in 3 suitable ways. Hence, you just follow the steps of every method. Hopefully, this article will help you to increase your excel skill.


Download Practice Workbook

Please download the workbook to practice yourself.


3 Effective Ways to Convert Date of Birth to Age in Excel

Let’s consider a dataset of Employee Information of ABC Traders. The dataset has two columns, B and C called Employee Name and Date of Birth. From here you need to Change the Date of Birth to Age to a fixed date in Excel. Let’s follow the steps of the methods carefully.

Dataset of how to convert date of birth to age in excel


1. Use of Generic Formula to Convert Date of Birth to Age in Excel

This is the first method to Change Date of Birth to Age. In our database, I added two new columns, D & E called Current Date and Age. Here, I will use a Generic Formula for the conversion. So, without any further delay, let’s see the following steps.

Use of Generic Formula to convert date of birth to age in excel

Steps:

  • First, select the E5 cell.
  • After that, write down the following formula in the Formula bar:
=INT((D5-C5)/365)

Use of Generic Formula to convert date of birth to age in excel

  • Then, press Enter.
  • As a consequence, you will find the result just like the picture given below. We can see that the result is in date format.

Use of Generic Formula to convert date of birth to age in excel

  • To fix this problem, go to the Home tab of your Toolbar.
  • Then, click on the Number You will find the format is in Date Format.

Use of Generic Formula to convert date of birth to age in excel

  • Change the format from Date to General.

Use of Generic Formula to convert date of birth to age in excel

  • Therefore, you will find the age in numeric format.
  • After that, Fill-handle the formula from E5 to E10.

Use of Generic Formula to convert date of birth to age in excel

  • Hence, you will find the result in the picture given below.

Use of Generic Formula to convert date of birth to age in excel

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


Similar Readings


2. Application of YEARFRAC Function to Convert Date of Birth to Age in Excel

In this part of the article, I will show another easy way to Change Date of Birth to Age in Excel. I will apply the YEARFRAC Function in this method. Follow the steps with me and enhance your excel skill.

Steps:

  • Select the E5 cell first.
  • Then, Write down the following formula in the Formula bar.
=ROUNDDOWN(YEARFRAC(C5, D5, 1), 0)

Here,

Application of YEARFRAC Function to Convert Date of Birth to Age in Excel

  • Then, Press the Enter.
  • Therefore, you will see the result in the following picture. Fill-handle the formula from E5 to E10.

  • Hence, you will find the result in the following picture.

Read More: How to Calculate Age from Birthday in Excel (8 Easy Methods)


3. Convert Date of Birth to Age in Excel Using DATEDIF Function

This is the last method of this article. You can Convert Date of Birth to Age by using the DATEDIF Function. I will show the process with the necessary steps and illustrations.

Steps:

  • First, select the E5 cell.
  • Then, write down the following formula in the cell.
=DATEDIF(C5,D5,"Y") & " Years, " & DATEDIF(C5,D5,"YM") & " Months, " &   DATEDIF(C5,D5,"MD") & " Days"

Convert Date of Birth to Age in Excel Using DATEDIF Function

  • Consequently, you will get the age with years months and dates.
  • Fill-handle the formula from the E5 to E10 cell.

  • Lastly, you will find the result just like the picture below.

Read More: How to Calculate Age Between Two Dates in Excel (6 Useful Methods)


Things to Remember

  • If the result shows in date format, do not forget to change the format in the Number option of the Home tab.

Conclusion

In this article, I have tried to explain how to Convert Date of Birth to Age in Excel. I hope, you have learned something new from this article. Now, extend your skill by following the steps of these methods. Hence, you will find such interesting blogs on our website Exceldemy.com. I hope you have enjoyed the whole tutorial. If you have any kind of queries feel free to ask me in the comment section. Don’t forget to give us your feedback.


Related Articles

Souptik Roy

Souptik Roy

Hello there. This is Souptik Roy. I graduated from Naval Architecture & Marine Engineering department. I am trying to explore the world of Microsoft Excel and want to increase my analytical power apart from my Engineering degree, as I have a curious mind. this is why I am trying to learn Excel Operations and write articles to help others.

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo