@CalcMgrExcelYEARFRAC

Purpose:

Returns the year fraction representing the number of whole days between start_date and end_date

Syntax:

Java Class: com.hyperion.calcmgr.common.excel.cdf.ExcelDateTimeFunctions.YEARFRAC(double,double,double)

CDF Spec: @CalcMgrExcelYEARFRAC(startDate, endDate, basis)

Note:

If you are passing a date in a Planning date format, you must convert the Planning date to an Excel date using @CalcMgrDateToExcel.

Note:

Date parameters used in @CalcMgrExcel functions must be in an Excel format. See @CalcMgrExcel Custom Functions with Date Parameters.