AnsweredAssumed Answered

Counting the months within a date range

Question asked by mchancevet@gmail.com on Apr 3, 2014
Latest reply on Apr 4, 2014 by raybaudi

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

Outcomes