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...