Calculating age in Excel
Posted on 2012-04-01
Given a person's Date of Birth (DOB), what is the simplest formula in Excel that will accurately display that person's current age (in years)? I emphasize "current" because I'm interested in a formula that will auto-update the result each day (i.e. the age will increase automatically on the person's birthday).