Use the YEARFRAC function to calculate the number of years between two dates. : YEARFRAC « Date Time functions « Microsoft Office Excel 2007 Tutorial






  1. Microsoft Office Excel 2007 Tutorial
  2. Date Time functions
  3. YEARFRAC
Input the formula: =YEARFRAC(A1,B1,1)
15.19.YEARFRAC
15.19.1.YEARFRAC(start_date,end_date,basis) returns the year fraction representing the number of whole days between start_date and end_date
15.19.2.Use the YEARFRAC function to calculate the number of years between two dates.
15.19.3.Return the age of the person whose date of birth you enter into cell A1