Mega Code Archive

 

Categories / MSOfficeExcel 2007 Tutorial / Date Time Functions

 

Use the YEARFRAC function to calculate the number of years between two dates

Input the formula: =YEARFRAC(A1,B1,1)