Calculate Your Age Using Excel


Have you ever thought that you can calculate your age with the help of Excel??

Well.. It is absolutely possible and Excel can calculate your age… but how?? Let’s learn through this blog post.

To calculate age, we can use DATEDIF function in excel. (We have already posted separate blog on this topic and if you want to learn in detail about DATEDIF function in excel, you can click here.)

For this we have to provide two inputs:

1. Date of Birth and
2. Today’s Date

In below image, we have entered first input i.e. Date of Birth in cells “A2” and second input i.e. Today’s Date in cell “B2”.


With the help of these two dates, we can:

1. Calculate the age in Years,
2. Calculate age in Years & Months
3. Calculate age in Years, Months & Days

Calculate Age in Years:

1. We want to calculate age in years in cells “C2”, so we have to select cell “C2”.


2. Enter below formula in cell “C2”
    =DATEDIF(A2,B2,"Y")


3. After entering the formula, we have to just press “Enter” key on our keyboard. With this we can see our age in years is now displayed in cell “C2”.



Calculate Age in Years and Months:

To calculate age in Years and Months we will use the same inputs as we have used in above steps. Also we have already calculated our age in years with the help of above steps, so in this section, we will only calculate the months.

1. We will calculate the completed months of our age in cells “D2”, so we have to select cell “D2”.


2. Enter below formula in cell “D2”
    =DATEDIF(A2,B2,"YM")


3. After entering the formula, we have to just press “Enter” key on our keyboard. With this we can see our age in Years and Months is now displayed in cell “D2”.



Calculate Age in Years, Months & Days:

To calculate age in Years, Months & Days, we will use the same inputs as we have used in above steps. Also we have already calculated our age in Years and Months in above steps, so in this section, we will only calculate the months.

1. We will calculate the completed Days of our age in cells “E2”, so we have to select cell “E2”.


2. Enter below formula in cell “E2”
    =DATEDIF(A2,B2,"MD")


3. After entering the formula, we have to just press “Enter” key on our keyboard. With this we can see our age in Years, Months & Days is now displayed in cell “E2”.


Thus, the age which we have calculated is “31 Years, 2 Months and 1 Day”. You can also try to calculate your age yourself and mention your queries in comments section.

Comments

Related Topics..

Fill Up, Down, Right & Left in Excel

Insert Multiple Rows in Excel Based On Cell Value

Excel Shortcuts Ctrl A to Ctrl Z

How to Remove Duplicate Entries from Multiple Columns in Excel

Excel Pivot Table

Select all cells highlighted with specific color at a time

Exploring Font Colors and Fill Colors in Excel

Insert Object in Excel

Title Bar in Excel

Number Filter in Excel