1 Reply Latest reply on Apr 4, 2014 12:50 AM by raybaudi

    Counting the months within a date range

    mchancevet@gmail.com

      Title

      Counting the months within a date range

      Post

           Hello,

           I have one item in my price table that my colleague insists should be billed per month rather than daily (for no good reason frankly other than that's what we have always done). I can't see how to define a calculation such that it counts the number of months within a date range and gives a whole number (for the part thereof component) for billable months.

           Eg .

           29/4/14 - 29/5/14 = 1 month

           29/4/14 - 14/6/14 = 2 months

           Thanks for any help,

           Morgan