=DATEDIF(birth date,as of date,”y”) is the most basic and accurate method for calculating age in Excel. This provides the rounded-down number of years.