View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
N Harkawat N Harkawat is offline
external usenet poster
 
Posts: 55
Default Year Fraction Formula (YEARFRAC)

Look in Excel help to get details of day count convention...default is 30/360

"IPerlovsky" wrote:

Does this formula produce a fraction consistent with part of the day count
using 365 days and part of the day count using 366 days when the start date
the formula references is in a 365 day year and the end date is in a 366 day
year and vice versa?
--
iperlovsky