@CalcMgrExcelDATEDIF

Purpose:

Calculates the number of days, months, or years between two dates.

Useful in formulas where you need to calculate an age

Syntax:

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

CDF Spec: @CalcMgrExcelDATEDIF(start_date, end_date,unit)

Note:

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