reeeval
10/21/2016 - 2:21 AM

Formula to count total month from start date and end date

Formula to count total month from start date and end date

MonthDiff
content_copyfile_download
IF(NOT(ISBLANK(Implementation_End_Date__c)) && NOT(ISBLANK(Implementation_Start_Date__c))
     ,(((YEAR(Implementation_End_Date__c) - YEAR(Implementation_Start_Date__c) - 1) *12) + (12 - MONTH(Implementation_Start_Date__c) +1) + MONTH(Implementation_End_Date__c))
     , 0
)