It’s not as complicated as it sounds, and there’s a handy function in Excel that can give you an exact age to the day. Read on for tips on how to calculate age in Excel.

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.