YEARFRAC and INT functions

You can also YEARFRAC with INT (an integer) to calculate age in Excel. The syntax to follow is '=INT (YEARFRAC (cell, TODAY ()))'. This function returns a difference based on years. For instance, if cell 'A1' has the date '12/01/2009' and cell 'B1' has the current date, when you insert the formula '=INT (YEARFRAC (B1, TODAY ()))' into C1it typically returns the difference of years between the two dates as an integer.