8 Replies Latest reply on Jul 20, 2018 7:17 AM by Ambo

    Has anyone used @CalcMgrExcelWORKDAY?

    Hyperion Freak

      Hi All,


      We have a requirement to calculate the end date of the task after deducting the weekends and holidays from the no of working days specified in the master. We have two masters, in one master we are specifying the no of days required to complete the task and in another master we are specifying the holidays.


      So we decided to use the @CalcMgrExcelWORKDAY function available in the EPBCS. But, unfortunately, it is not giving us the proper output.


      If anyone has used this function before please guide us how to use this function and what should be the syntax for this function.


      Following are the instructions available in the Oracle guide:


      @CalcMgrExcelWORKDAYReturns the serial number of the date before or after a specified number of workdays

      Java Class: com.hyperion.calcmgr.common.excel.cdf.ExcelDateTimeFunctions.WORKDAY(double,double,double[])

      CDF Spec: @CalcMgrExcelWORKDAY(startDate, days, holidays)

      Thank You.