Calculating months from days
Hi! I have a question that I imagine will be super easy for the wizards on this forum.
I have a calculation field that uses a basic calculation to get the number of days in a period:
DaysLeftInPeriod = PeriodEndDate - PeriodStartDate
I'd like to deduce the months left in the period using a more precise calculation than the one I'm currently using:
Case (Not IsEmpty (PeriodEndDate) ; Round (DaysLeftInPeriod / 30 ; 1 ) ; 0 )
I know that this gives me inconsistent months, since some months have 31 days. Is there a function or calculation that calculates months from days more accurately?