Hi,

I am trying to calculate the number of months between my contract start and end dates on an opportunity.  I would like it to calculate partial months though and it doesn't.  Can someone please help?

IF(DAY(Contract_Start_Date__c) = 1, (((YEAR( Contract_End_Date__c ) - YEAR( Contract_Start_Date__c )) *12) + (MONTH( Contract_End_Date__c ) - MONTH( Contract_Start_Date__c ) ) +1), ((YEAR( Contract_End_Date__c) - YEAR( Contract_Start_Date__c)) *12) + (MONTH( Contract_End_Date__c) - MONTH( Contract_Start_Date__c) ) )