Date Time Functions MSOfficeExcel 2007 Tutorial

Input the formula: =INT(YEARFRAC(TODAY(),A1,1))