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

Data Analysis

  • How To Compare Two Lists in Excel
  • Conditional Formatting New Rule with Formulas in Excel
  • Subtotal function in Excel
  • Excel Pie Chart
  • How To Create Frequency Distribution in Excel

References

  • How to use Excel ROW Function
  • How to use Excel COLUMN Function
  • How to retrieve first match between two ranges in Excel
  • Count rows that contain specific values in Excel
  • How to get address of named range in Excel

Data Validations

  • Excel Data validation must contain specific text
  • Excel Data validation unique values only
  • Excel Data validation number multiple 100
  • Excel Data validation only dates between
  • Excel Data validation exists in list

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

  • Extract multiple matches into separate rows in Excel
  • Check multiple cells are equal in Excel
  • IF, AND, OR and NOT Functions Examples in Excel
  • IF function: Description, Usage, Syntax, Examples and Explanation
  • IF with boolean logic in Excel

Date Time

  • NETWORKDAYS.INTL function: Description, Usage, Syntax, Examples and Explanation
  • Custom weekday abbreviation in Excel
  • Add workdays to date custom weekends in Excel
  • Count day of week between dates in Excel
  • Pad week numbers with zeros in Excel

Grouping

  • Group times into unequal buckets in Excel
  • How to randomly assign data to groups in Excel
  • Calculate conditional mode with criteria in Excel
  • Group numbers with VLOOKUP in Excel
  • Map inputs to arbitrary values in Excel

General

  • Transpose: Switch ‘Rows to Columns’ or ‘Columns to Rows’ in Excel
  • How to calculate profit margin percentage in Excel
  • How to test a range for numbers in Excel
  • How to password protect excel sheet?
  • Advanced Number Formats in Excel
© 2026 xlsoffice . All Right Reserved. | Teal Smiles | Abbreviations And Their Meaning