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.

 

Examples

 

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”)