11 Replies Latest reply: Oct 13, 2016 12:54 PM by Sunny Talwar RSS

    Number of days in a month

    Ganesh Bagavathi

      Hello,

       

      I am trying to calculate the no of days in a particular month, and in my case it is not the normal calendar month rather a Fiscal month.

      Details are attached here.

       

         

      Fisc PeriodSales end of Fisc periodNo of Fiscal days
      2016058909.1928
      2016064938.335
      2016071099928
      201608548728
      2016091187835
      20161054898

       

      in the above table, the last column is based on the Fisc_day_of_month column in the Calendar sheet.

      Please let  me know if more information is needed.