How to Get Age from DOB in Excel: A Step-by-Step Guide for Beginners

how to get age from dob in excel

Calculating someone’s age from their date of birth (DOB) in Excel can be done quickly with a simple formula. This article will guide you through a step-by-step process to achieve this. By the end, you’ll be able to calculate age accurately using Excel formulas. Let’s dive in!

Step-by-Step Tutorial on how to get age from dob in excel

This section will walk you through the process of calculating age from a date of birth in Excel. Follow these steps carefully, and you’ll have your answer in no time.

Step 1: Open Excel and Input Data

Enter the date of birth in a cell, like A1.

Ensure you format the cell correctly. Click on the cell, go to the "Home" tab, and choose the "Date" format under the "Number" section.

Step 2: Create the Formula

In a different cell, type the formula =DATEDIF(A1, TODAY(), "Y").

This formula calculates the difference between the date in cell A1 and today’s date, giving you the age in years.

Step 3: Press Enter

Hit the Enter key to see the result.

Excel will now display the age in the selected cell. Double-check to make sure the date is correct.

Step 4: Format the Result Cell

Adjust the formatting of the result cell if needed.

Right-click the cell, choose "Format Cells," and select "Number" if you prefer a numerical format without decimals.

Step 5: Save Your Work

Save the Excel file to ensure you don’t lose your calculations.

Click on the "File" tab, choose "Save As," and give your file a name and location.

Once you complete these steps, you’ll have successfully calculated the age from the date of birth in Excel.

Tips on how to get age from dob in excel

To make the task even easier, here are some additional tips:

  • Double-check the date format: Always ensure your date of birth is in the correct format (e.g., MM/DD/YYYY).
  • Use cell references: If you have multiple dates of birth, use cell references in your formula to quickly calculate ages.
  • Error checking: If you see an error, verify the cell contents and formula accuracy.
  • Copy and paste: You can drag the fill handle to copy the formula to other cells.
  • Combine with other functions: For more complex calculations, combine DATEDIF with other Excel functions like IF for conditional logic.

Frequently Asked Questions

What if the date format is different?

Check your regional settings and adjust the cell format to match the date format you are using.

Can I calculate age in months or days?

Yes, use =DATEDIF(A1, TODAY(), "M") for months and =DATEDIF(A1, TODAY(), "D") for days.

What if the formula shows an error?

Ensure the date is valid and the cell format is correct. Also, make sure you have no typos in the formula.

Is there a way to automatically update the age?

The TODAY() function auto-updates daily, ensuring the age is always current.

Can I use this method in Google Sheets?

Yes, the DATEDIF function works similarly in Google Sheets.


  1. Step 1: Open Excel and Input Data
  2. Step 2: Create the Formula
  3. Step 3: Press Enter
  4. Step 4: Format the Result Cell
  5. Step 5: Save Your Work


Calculating age from a date of birth in Excel is straightforward once you know the right steps. By using the DATEDIF function, you can quickly and accurately determine age. With this knowledge, you can handle various tasks that require age calculations, from managing a contact list to analyzing customer data.

Keep practicing, and soon it will become second nature. If you’re ready to take your Excel skills to the next level, consider exploring more advanced functions and integrating them into your daily tasks. Happy calculating!

Get Our Free Newsletter

How-to guides and tech deals

You may opt out at any time.
Read our Privacy Policy