- MS Excel Basics
- Excel - Home
- Excel - Getting Started
- Excel - Explore Window
- Excel - Backstage
- Excel - Entering Values
- Excel - Move Around
- Excel - Save Workbook
- Excel - Create Worksheet
- Excel - Copy Worksheet
- Excel - Hiding Worksheet
- Excel - Delete Worksheet
- Excel - Close Workbook
- Excel - Open Workbook
- Excel - Context Help

- Editing Worksheet
- Excel - Insert Data
- Excel - Select Data
- Excel - Delete Data
- Excel - Move Data
- Excel - Rows & Columns
- Excel - Copy & Paste
- Excel - Find & Replace
- Excel - Spell Check
- Excel - Zoom In-Out
- Excel - Special Symbols
- Excel - Insert Comments
- Excel - Add Text Box
- Excel - Undo Changes

- Formatting Cells
- Excel - Setting Cell Type
- Excel - Setting Fonts
- Excel - Text Decoration
- Excel - Rotate Cells
- Excel - Setting Colors
- Excel - Text Alignments
- Excel - Merge & Wrap
- Excel - Borders and Shades
- Excel - Apply Formatting

- Formatting Worksheets
- Excel - Sheet Options
- Excel - Adjust Margins
- Excel - Page Orientation
- Excel - Header and Footer
- Excel - Insert Page Breaks
- Excel - Set Background
- Excel - Freeze Panes
- Excel - Conditional Format

- Working with Formula
- Excel - Creating Formulas
- Excel - Copying Formulas
- Excel - Formula Reference
- Excel - Using Functions
- Excel - Builtin Functions

- Advanced Operations
- Excel - Data Filtering
- Excel - Data Sorting
- Excel - Using Ranges
- Excel - Data Validation
- Excel - Using Styles
- Excel - Using Themes
- Excel - Using Templates
- Excel - Using Macros
- Excel - Adding Graphics
- Excel - Cross Referencing
- Excel - Printing Worksheets
- Excel - Email Workbooks
- Excel- Translate Worksheet
- Excel - Workbook Security
- Excel - Data Tables
- Excel - Pivot Tables
- Excel - Simple Charts
- Excel - Pivot Charts
- Excel - Keyboard Shortcuts

- MS Excel Resources
- Excel - Quick Guide
- Excel - Useful Resources
- Excel - Discussion

# How to calculate age from ID number in Excel?

Let's consider that you have a list of ID numbers that contains 13 to 15 digits of numbers, and in those 13 to 15 digits, the first six digits are the date of birth of the candidate or a specific person, so that you have a list of ID numbers.

For instance, consider that you have an ID number of one person 9304304413002 in this Id first 6 digits is the date of birth 1993/04/30. From this ID number, how will you calculate the age? In this article, I will introduce the formula which is very easy that quickly finds out the age of a person from the given ID number.

Follow the steps given below to understand easily how to calculate the age from the ID number in the Excel sheet.

### Step 1

Open a Microsoft excel sheet and enter the ID numbers as shown in the below screenshots for your reference. You can change the ID numbers as per your wish or as per the given by your company.

### Step 2

Now you need to select a blank cell and enter the below given formula to calculate the age from the given ID number. In our case, I will enter the formula in the cell B2 as shown in the below screenshot for your reference.

**=DATEDIF(DATE(IF(LEFT(A2,2)>TEXT(TODAY(),"YY"),"19"&LEFT(A2,2),"20"&LEFT A2,2)),MID(A2,3,2),MID(A2,5,2)),TODAY(),"y")**

### Step 3

Now you need to drag the fill handle down till you want to calculate the age for the ID numbers given. Apply the formula and the ages will be calculated from the ID numbers as shown in the below screenshot for you reference.

**Note** − In the above formula, A2 contains the list of ID numbers that you want to calculate the age. If the year is less than the present year, then it will be considered 20, otherwise 19 if the year is greater than the present year.

## Conclusion

In this tutorial, we used a simple example to demonstrate how you can calculate age from ID number in Excel.

- Related Articles
- How to Calculate Age in Excel from Birthday?
- How to calculate average age by year/month/date in Excel?
- How to calculate the next age of a person’s birthday in Excel?
- How to calculate age in years from birthdate in MySQL?
- How to Add a Unique ID Number Column for Duplicate Rows in Excel?
- How to calculate quarter and year from date in Excel?
- How to calculate average cells from different sheets in Excel?
- Calculate age from date of birth in MySQL?
- How to calculate retirement date from date of birth in Excel?
- How to calculate average speed from distance and time in Excel?
- Calculate Age from given Date of Birth in MySQL?
- How to calculate end date from start date and duration in Excel?
- How to calculate the length of service from hire date in Excel?
- How to calculate Easter date in Excel?
- How to calculate sales tax in Excel?