To calculate the age, the DATEDIF function, set to check year, determines the number of years between the date in the DOB cell and the current date.

Finding the exact difference between two dates in Excel may not be the most used feature, but it can be a lot of fun. A classic example is working out someone’s age. It’s not as complicated as it ...