The duration of an item represented as months. 


Note: A month in this case is represented as 30.4 days (365/12). 


Type of Data Returned


Will return the number of months the item has for duration.




Increasing the value of the duration by a month


durnmnths + 31


Determining if an item is deemed “long” or “short” based upon its duration in months.


IF(durnmnths>12, “Long”, “Short”)