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”.
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”.
=DATEDIF(A2,B2,"Y")
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")
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")
Comments
Post a Comment