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

Data Analysis

  • How to Use Solver Tool in Excel
  • Chart Axes in Excel
  • Everything about Charts in Excel
  • How to do a t-Test in Excel?
  • What-If Analysis: Scenarios and Goal Seek in Excel

References

  • Perform case-sensitive Lookup in Excel
  • How to use Excel INDIRECT Function
  • How to create dynamic named range with OFFSET in Excel
  • To count total rows in a range in Excel
  • How to retrieve first match between two ranges in Excel

Data Validations

  • Excel Data validation date in next 30 days
  • Excel Data validation unique values only
  • Excel Data validation specific characters only
  • Excel Data validation number multiple 100
  • Excel Data validation must not contain

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

  • Check multiple cells are equal in Excel
  • TRUE function: Description, Usage, Syntax, Examples and Explanation
  • SWITCH function example in Excel
  • OR function: Description, Usage, Syntax, Examples and Explanation
  • IF with boolean logic in Excel

Date Time

  • Convert Excel time to decimal hours in Excel
  • Calculate retirement date in Excel
  • How to calculate nth day of week in month in Excel
  • Calculate number of hours between two times in Excel
  • Sum through n months in Excel

Grouping

  • Group times into unequal buckets in Excel
  • Group arbitrary text values in Excel
  • Group numbers at uneven intervals in Excel
  • Group times into 3 hour buckets in Excel
  • Calculate conditional mode with criteria in Excel

General

  • Hide and Unhide Columns or Rows in Excel
  • Excel Autofill Cell Ranges, Copy, Paste
  • Subtotal by color in Excel
  • Count cells less than in Excel
  • Excel Default Templates
© 2025 xlsoffice . All Right Reserved. | Teal Smiles | Abbreviations And Their Meaning