Calculating age in Excel

If you have an event date and a date of birth, Excel will calculate the age-at-event for you through this formula:

=INT((A1-B1)/365.25)

Where A1 is the cell with the event date, and B1 is the cell with the birthdate.

Shortcut courtesy of http://excel-formulas.blogspot.com/2005/08/calculate-age-in-excel.html