Skip to content
Free Excel Tutorials
  • Home
  • Excel For Beginners
  • Excel Intermediate
  • Advanced Excel For Experts

Data Analysis

  • Data Series in Excel
  • Conditional Formatting Icon Sets Examples in Excel
  • Get column index in Excel Table
  • How to create Gauge Chart in Excel
  • Subtotal function in Excel

References

  • How to get address of last cell in range in Excel
  • Count unique text values with criteria
  • How to retrieve first match between two ranges in Excel
  • How to get relative column numbers in a range in Excel
  • How to get address of named range in Excel

Data Validations

  • Excel Data validation allow uppercase only
  • Excel Data validation specific characters only
  • Excel Data validation only dates between
  • Excel Data validation with conditional list
  • Excel Data validation no punctuation

Get age from birthday in Excel

by

This tutorial shows how to get age from birthday in Excel using example below.

If you need to calculate a person’s age from their birth date, you can do so with the YEARFRAC, INT, and TODAY functions.

As stated in the formula below, birthdate is the person’s birthday with year, and TODAY supplies the date on which to calculate age. Because this formula uses the TODAY function, it will continue to calculate the correct age in the future as well.

Formula

=INT(YEARFRAC(birthdate,TODAY()))

Explanation

In the example, the active cell contains this formula:

=INT(YEARFRAC(D4,TODAY()))

How the formula works

YEARFRAC calculates a decimal number representing the fraction of a year between two dates. To work out the fraction of a year as a decimal value, Excel uses whole days between two dates. This is straightforward in Excel, because all dates are simply serial numbers.

So, in this case, birthdate is supplied as the start_date from cell D4, and today’s date is supplied as the end_date, courtesy of the TODAY function.

The result of YEARFRAC for Michael Chang, here in February 2016, is something like this:

14.7333333333333

Next, the INT function takes over and rounds down that number to the integer value, which is the number 14. Even though Michael is close to being 15 years old, he’s still just 14 by the books, so this is the correct result.

If you want to calculate a person’s age as of a given date, just replace the TODAY function with that date, or a cell reference to that date.

Adult or Minor

To check a birthday and return “Minor” or “Adult”, you can wrap the age formula in the IF function like so:

=IF(INT(YEARFRAC(A1,TODAY()))<18,"Minor","Adult")

You can replace 18 with whatever age makes sense for your situation.

Age on specific date

To calculate age on a specific date, given a birth date, you can use the DATE function instead of the TODAY function like so:

=INT(YEARFRAC(A1,DATE(2016,1,1)))

Where A1 contains a birth date.

Post navigation

Previous Post:

DECIMAL function: Description, Usage, Syntax, Examples and Explanation

Next Post:

AVERAGE function: Description, Usage, Syntax, Examples and Explanation

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Learn Basic Excel

Ribbon
Workbook
Worksheets
Format Cells
Find & Select
Sort & Filter
Templates
Print
Share
Protect
Keyboard Shortcuts

Categories

  • Charts
  • Data Analysis
  • Data Validation
  • Excel Functions
    • Cube Functions
    • Database Functions
    • Date and Time Functions
    • Engineering Functions
    • Financial Functions
    • Information Functions
    • Logical Functions
    • Lookup and Reference Functions
    • Math and Trig Functions
    • Statistical Functions
    • Text Functions
    • Web Functions
  • Excel VBA
  • Excel Video Tutorials
  • Formatting
  • Grouping
  • Others

Logical Functions

  • Excel If, Nested If, And/Or Criteria Examples
  • How to use Excel NOT Function
  • Not Equal To ‘<>‘ operator in Excel
  • How to use Excel AND Function
  • IF function: Description, Usage, Syntax, Examples and Explanation

Date Time

  • Get last weekday in month in Excel
  • How to get Holiday Date from Year in Excel
  • How to calculate project start date based on end date in Excel
  • How to enter Today’s Date or Static Date and Time in Excel
  • Calculate retirement date in Excel

Grouping

  • Group times into 3 hour buckets in Excel
  • How to randomly assign people to groups in Excel
  • How to randomly assign data to groups in Excel
  • Map text to numbers in Excel
  • Calculate conditional mode with criteria in Excel

General

  • Basic numeric sort formula in Excel
  • Check if range contains a value not in another range in Excel
  • How to fill cell ranges with random number from fixed set of options in Excel
  • List worksheet index numbers in Excel
  • Find, Select, Replace and Go To Special in Excel
© 2025 xlsoffice . All Right Reserved. | Teal Smiles | Abbreviations And Their Meaning