YEARFRAC(start_date,end_date,basis) returns the year fraction representing the number of whole days between start_date and end_date : YEARFRAC « Date Time functions « Microsoft Office Excel 2007 Tutorial






  1. Microsoft Office Excel 2007 Tutorial
  2. Date Time functions
  3. YEARFRAC
If basis = 0 or omitted, Day count basis is US (NASD) 30/360.

If basis = 1, Day count basis is Actual/actual.

If basis = 2, Day count basis is Actual/360.

If basis = 3, Day count basis is Actual/365.

If basis = 4, Day count basis is European 30/360.

Input the formula: =YEARFRAC("1/1/2007", "7/30/2007", 2). Press Enter to get the result.








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