How to Calculate Age Using Date of Birth in Excel

Introduction

This tutorial will guide you through the process of calculating age using a date of birth in Excel. You will learn how to determine the exact number of years and months between a given date of birth and the current date. This skill is useful for various applications, including data analysis, reporting, and personal record-keeping.

Step 1: Set Up Your Excel Worksheet

1. Open Excel: Launch the Microsoft Excel application on your computer.
2. Create a New Workbook: Start a new spreadsheet for your calculations.
3. Input Data:
   • In cell A1, type "Date of Birth".
   • In cell A2, enter the date of birth you want to calculate the age for (e.g., 01/01/1990).
   • In cell B1, type "Age".

Step 2: Calculate the Age in Years

1. Select Cell B2: Click on cell B2 where you will enter the formula.
2. Enter the Formula: Type the following formula:

   =DATEDIF(A2, TODAY(), "Y")
   

   • This formula calculates the number of complete years between the date of birth in A2 and today's date.
3. Press Enter: After typing the formula, hit Enter to see the result.

Step 3: Calculate the Age in Months

1. Select Cell C1: In cell C1, type "Months" to label the next calculation.
2. Select Cell C2: Click on cell C2.
3. Enter the Formula: Type the following formula:

   =DATEDIF(A2, TODAY(), "YM")
   

   • This formula calculates the number of remaining months after the last completed year.
4. Press Enter: Hit Enter to view the number of months.

Step 4: Combine Years and Months

1. Select Cell D1: In cell D1, type "Age (Years and Months)".
2. Select Cell D2: Click on cell D2.
3. Enter the Formula: Use the following formula to combine years and months:

   =DATEDIF(A2, TODAY(), "Y") & " years and " & DATEDIF(A2, TODAY(), "YM") & " months"
   

   • This will provide a readable format for age.
4. Press Enter: Confirm the result to see the age expressed in years and months.

Conclusion

You have successfully calculated age in Excel using a date of birth. By employing the DATEDIF function, you can easily determine the number of years and months between any date of birth and today. This method can be applied to multiple entries by dragging the fill handle down to apply formulas to additional rows. For further practice, consider experimenting with different dates of birth in your Excel sheet!