Skip to main content

How to calculate age from birth date in Google Sheets and Excel?

Author Xiaoyang Last modified

Have you ever tried to calculate age from a birth date in Google Sheets? In this article, I will introduce some formulas to help you solve this task quickly and easily.

Calculate age based on birth date with formulas in Google Sheets

Calculate age based on birth date with a handy feature in Microsoft Excel

Calculate age based on birth date with formulas in Google Sheets

The following formulas can help you calculate age from a birth date. Please do as this:

1. Enter the below formula into a blank cell which will place the age result, and then drag the fill handle down to get the ages from the relative cells, all the ages will be calculated at once. See screenshot:

=IF(B2,DATEDIF(B2,TODAY(),"Y"),"")

A screenshot of the Google Sheets formula to calculate age from a birth date

Tips: To get the exact years, months, and days from the birth date, apply the following formula. You will see the result as shown below.

=datedif(B2, today(), "Y") & " years, " & datedif(B2, today(), "YM") & " months, " & datedif(B2, today(), "MD") & " days"

A screenshot showing the Google Sheets formula for calculating years, months, and days from a birth date

Calculate age based on birth date with a handy feature in Microsoft Excel

To calculate age from a birth date in Microsoft Excel, Kutools for Excel's Date & Time Helper utility can help. With this feature, you can calculate age based on the birth date from either today or a specific date.

Kutools for Excel offers over 300 advanced features to streamline complex tasks, boosting creativity and efficiency. Itegarate with AI capabilities, Kutools automates tasks with precision, making data management effortless. Detailed information of Kutools for Excel...         Free trial...

1. Click a cell where you want to output the result, and then click Kutools > Formula Helper > Date & Time helper, see screenshot:

A screenshot of the Kutools Date & Time Helper in Excel

2. In the Date & Time Helper dialog box, please do the following operations:

  • Select Age option from the Type section;
  • From the Date of Birth section, select the cell that contains the birth date that you want to calculate the age;
  • Then, choose Today or Specified date that you want to calculate date based on;
  • At last, specify the output result type as you need.

A screenshot of the Date & Time Helper dialog box

3. Then click Ok button, the first age has been calculated, and then select the cell and drag the fill handle down to get the ages from other date cells, see screenshot:

A screenshot showing the age calculated with Kutools

Kutools for Excel - Supercharge Excel with over 300 essential tools. Enjoy permanently free AI features! Get It Now

More relative articles:

  • Calculate Age On A Specific Or Future Date
  • For example, you have a person’s date of birth, if you need to calculate the age of this person based on a future or specific date, the following methods will help you achieve it .
  • Calculate Age From ID Number In Excel
  • Supposing, you have a list of ID numbers which contain 13 digit numbers, and the first 6 numbers is the birth date. For example, the ID number 9808020181286 means the birth date is 1998/08/02. How could you get the age from ID number as following screenshot shown quickly in Excel?
  • Calculate The Difference Between Two Dates
  • When dealing with the dates in a worksheet, you may need to calculate the difference between two given dates for getting the number of days, weeks, months or years. This article, I will talk about how to solve this task in Excel.
  • Calculate Next Age Of A Person’s Birthday
  • Normally, we can calculate a person’s age based on the birth date with a formula, but, have you ever considered calculating the age of his next birthday in Excel? Which means to calculate how old he is going to be in next birthday. This article, I will talk about some formulas for solving this task in Excel.

Best Office Productivity Tools

🤖 Kutools AI Aide: Revolutionize data analysis based on: Intelligent Execution   |  Generate Code  |  Create Custom Formulas  |  Analyze Data and Generate Charts  |  Invoke Kutools Functions…
Popular Features: Find, Highlight or Identify Duplicates   |  Delete Blank Rows   |  Combine Columns or Cells without Losing Data   |   Round without Formula ...
Super Lookup: Multiple Criteria VLookup  |   Multiple Value VLookup  |   VLookup Across Multiple Sheets   |   Fuzzy Lookup ....
Advanced Drop-down List: Quickly Create Drop Down List   |  Dependent Drop Down List   |  Multi-select Drop Down List ....
Column Manager: Add a Specific Number of Columns  |  Move Columns  |  Toggle Visibility Status of Hidden Columns  |  Compare Ranges & Columns ...
Featured Features: Grid Focus   |  Design View   |   Big Formula Bar   |  Workbook & Sheet Manager   |  Resource Library (Auto Text)   |  Date Picker   |  Combine Worksheets   |  Encrypt/Decrypt Cells   |  Send Emails by List   |  Super Filter   |   Special Filter (filter bold/italic/strikethrough...) ...
Top 15 Toolsets:  12 Text Tools (Add Text, Remove Characters, ...)   |   50+ Chart Types (Gantt Chart, ...)   |   40+ Practical Formulas (Calculate age based on birthday, ...)   |   19 Insertion Tools (Insert QR Code, Insert Picture from Path, ...)   |   12 Conversion Tools (Numbers to Words, Currency Conversion, ...)   |   7 Merge & Split Tools (Advanced Combine Rows, Split Cells, ...)   |   ... and more
Use Kutools in your preferred language – supports English, Spanish, German, French, Chinese, and 40+ others!

Supercharge Your Excel Skills with Kutools for Excel, and Experience Efficiency Like Never Before. Kutools for Excel Offers Over 300 Advanced Features to Boost Productivity and Save Time.  Click Here to Get The Feature You Need The Most...

Office Tab Brings Tabbed interface to Office, and Make Your Work Much Easier

  • Enable tabbed editing and reading in Word, Excel, PowerPoint, Publisher, Access, Visio and Project.
  • Open and create multiple documents in new tabs of the same window, rather than in new windows.
  • Increases your productivity by 50%, and reduces hundreds of mouse clicks for you every day!