Counting the months within a date range
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.
29/4/14 - 29/5/14 = 1 month
29/4/14 - 14/6/14 = 2 months
Thanks for any help,