The Ultimate Formula: Easily Computing Your or Someone's Age Using Excel

The Ultimate Formula: Easily Computing Your or Someone's Age Using Excel

Paul Lv12

The Ultimate Formula: Easily Computing Your or Someone’s Age Using Excel

To find someone or something’s age in Microsoft Excel, you can use a function that displays the age in years, months, and even days. We’ll show you how to use this function in your Excel spreadsheet.

We’ve used the day-month-year format in the examples in this guide, but you can use any date format you prefer.

How to Calculate Age in Years

To calculate someone’s age in years, use Excel’s DATEDIF function. This function takes the date of birth as an input and then generates the age as an output.

For this example, we’ll use the following spreadsheet. In the spreadsheet, the date of birth is specified in the B2 cell, and we’ll display the age in the C2 cell.

A sample spreadsheet to find age in years in Excel.

First, we’ll click the C2 cell where we want to display the age in years.

Click the C2 cell in the spreadsheet in Excel.

In the C2 cell, we’ll type the following function and press Enter. In this function, “B2” refers to the date of birth, “TODAY()” finds today’s date, and “Y” indicates that you wish to see the age in years.

=DATEDIF(B2,TODAY(),”Y”)

Type =DATEDIF(B2,TODAY(),"Y") in the C2 cell and press Enter in Excel.

And immediately, you’ll see the completed age in the C2 cell.

If you see a date instead of years in the C2 cell, then in Excel’s Home > Number section, click the “Date” drop-down menu and select “General.” You’ll now see years instead of a date.

Age in years in Excel.

Excel is so powerful that you can even use it to calculate uncertainty .

Related: How to Get Microsoft Excel to Calculate Uncertainty

How to Calculate Age in Months

You can use the DATEDIF function to find someone’s age in months, too.

For this example, again, we’ll use the data from the above spreadsheet, which looks like this:

A sample spreadsheet to find age in months in Excel.

Easy and Safe Partition Software & Hard Disk Manager

In this spreadsheet, we’ll click the C2 cell where we want to display the age in months.

Click the C2 cell in the spreadsheet in Excel.

In the C2 cell, we’ll type the following function. The “M” argument here tells the function to display the result in months.

=DATEDIF(B2,TODAY(),”M”)

Enter =DATEDIF(B2,TODAY(),"M") in the C2 cell and press Enter in Excel.

Press Enter and you’ll see the age in months in the C2 cell.

Age in months in Excel.

PDF application, powered by AI-based OCR, for unified workflows with both digital and scanned documents.

vMix HD - Software based live production. vMix HD includes everything in vMix Basic HD plus 1000 inputs, Video List, 4 Overlay Channels, and 1 vMix Call
This bundle includes Studio 200 for vMix from Virtualsetworks, HTTP Matrix 1.0 automation scheduler, and 4 introductory training videos from the Udemy vMix Basic to Amazing course.

How to Calculate Age in Days

Excel’s DATEDIF function is so powerful that you can use it to find someone’s age in days as well.

To show you a demonstration, we’ll use the following spreadsheet:

A sample spreadsheet to find age in days in Excel.

In this spreadsheet, we’ll click the C2 cell where we want to display the age in days.

Click the C2 cell in the spreadsheet in Excel.

In the C2 cell, we’ll type the following function. In this function, the “D” argument tells the function to display the age in days.

=DATEDIF(B2,TODAY(),”D”)

Type =DATEDIF(B2,TODAY(),"D") in the C2 cell in Excel.

CollageIt Pro

Press Enter and you’ll see the age in days in the C2 cell.

Age in days in Excel.

Epubor Audible Converter for Win: Download and convert Audible AAXC/AA/AAX to MP3 with 100% original quality preserved.

You can use Excel to add and subtract dates , too.

DEX 3 RE is Easy-To-Use DJ Mixing Software for MAC and Windows Designed for Today’s Versatile DJ.

Mix from your own library of music, iTunes or use the Pulselocker subsciprtion service for in-app access to over 44 million songs. Use with over 85 supported DJ controllers or mix with a keyboard and mouse. 

DEX 3 RE is everything you need without the clutter - the perfect 2-deck mixing software solution for mobile DJs or hard-core hobbiests. 
PCDJ DEX 3 RE (DJ Software for Win & MAC - Product Activation For 3 Machines)

How to Calculate Age in Years, Months, and Days at the Same Time

To display someone’s age in years, months, and days at the same time, use the DATEDIF function with all the arguments combined. You can also combine text from multiple cells into one cell in Excel.

We’ll use the following spreadsheet for the calculation:

A sample spreadsheet to find age in years, months, and days in Excel.

In this spreadsheet, we’ll click the C2 cell, type the following function, and press Enter:

=DATEDIF(B2,TODAY(),”Y”) & “ Years “ & DATEDIF(B2,TODAY(),”YM”) & “ Months “ & DATEDIF(B2,TODAY(),”MD”) & “ Days”

Enter =DATEDIF(B2,TODAY(),"Y") & " Years " & DATEDIF(B2,TODAY(),"YM") & " Months " & DATEDIF(B2,TODAY(),"MD") & " Days" in the C2 cell in Excel.

In the C2 cell, you’ll see the age in years, months, and days.

Age in years, months, and days in Excel.

How to Calculate Age on a Specific Date

With Excel’s DATEDIF function, you can go as far as to finding someone’s age on a specific date.

To show you how this works, we’ll use the following spreadsheet. In the C2 cell, we’ve specified the date on which we want to find the age.

A specific date in the C2 cell in Excel.

We’ll click the D2 cell where we want to show the age on the specified date.

Click the D2 cell in Excel.

In the D2 cell, we’ll type the following function. In this function, “C2” refers to the cell where we’ve entered the specific date, on which the answer will be based:

=DATEDIF(B2,C2,”Y”)

Enter =DATEDIF(B2,C2,"Y") in the D2 cell in Excel.

Press Enter and you’ll see the age in years in the D2 cell.

Age on a specific date in the D2 cell in Excel.

And that’s how you find someone or something’s oldness in Microsoft Excel!


With Excel, did you know you can find how many days until an event ? This is super useful if you’re looking forward to an important event in your life!

| | Mastering Excel Functions | | |
| —————————- | ——————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————————- | |
| Functions | AVERAGE · CONCATENATE · COUNT · COUNTIF · DATEDIF · FILTER · FREQUENCY · FV · HYPERLINK · IF · IFS · IMAGE · INDEX · IS · LEN · MATCH · MEDIAN · RAND · ROUND · RRI · SORT · SQRT · SUBSTITUTE · SUBTOTAL · SUM · SUMIF · TODAY · TRIM · TRUNC · VLOOKUP · WEEKDAY · XLOOKUP · YEAR | |
| Types | Basic · Budgeting · Data Entry · Logical · Text · Time and Date | |
| Explained | Copying Formulas · Evaluating Formulas · Finding Functions · Fixing Formula Errors · Functions vs Formulas · Comparing Lookup Functions · Locking Formulas · Structuring Formulas · Translating Formulas | |

  • Title: The Ultimate Formula: Easily Computing Your or Someone's Age Using Excel
  • Author: Paul
  • Created at : 2024-08-28 05:23:10
  • Updated at : 2024-08-29 05:23:10
  • Link: https://win-able.techidaily.com/the-ultimate-formula-easily-computing-your-or-someones-age-using-excel/
  • License: This work is licensed under CC BY-NC-SA 4.0.