Skip to main content
Topics#Data ManagementMatt Brown's Question
Matt Brown (Appirio) asked in #Data Management
Apr 8, 2011, 12:57 PM

Calculate # of Months between a Start and End Date Formula

 I need to calculate the number of months (Number Formula) between a Start and End Date please.

 

Start_Date__c

 

End_Date__c
6 answers
  1. Chris Putnam (Rock Consulting Group)
    Feb 21, 2018, 2:19 PM
    This is what we did to find the term in months with decimial points like 10.15 Months

     

    IF(AND(DAY(SBQQ__EndDate__c)=29,MONTH(SBQQ__EndDate__c)=2,MONTH(SBQQ__StartDate__c)=2),(DAY(SBQQ__EndDate__c)-DAY(SBQQ__StartDate__c)+1)/29,IF(AND(DAY(SBQQ__EndDate__c)=29,MONTH(SBQQ__EndDate__c)=2),((DAY(SBQQ__StartDate__c)-DAY(SBQQ__EndDate__c)-1)*-1)/29,IF(AND(DAY(SBQQ__EndDate__c)=28,MONTH(SBQQ__EndDate__c)=2),((DAY(SBQQ__StartDate__c)-DAY(SBQQ__EndDate__c)-1)*-1)/28,IF(DAY(SBQQ__StartDate__c)=DAY(SBQQ__EndDate__c),((DAY(SBQQ__EndDate__c)-DAY(SBQQ__StartDate__c))+1)/30,IF(AND(DAY(SBQQ__EndDate__c)=31,DAY(SBQQ__StartDate__c)=1),((DAY(SBQQ__EndDate__c)-DAY(SBQQ__StartDate__c)))/30,IF(AND(DAY(SBQQ__EndDate__c)=31),((DAY(SBQQ__EndDate__c)-DAY(SBQQ__StartDate__c)-1))/30,IF(AND(DAY(SBQQ__EndDate__c)=30,DAY(SBQQ__StartDate__c)=1),((DAY(SBQQ__EndDate__c)-DAY(SBQQ__StartDate__c)+1))/30,IF(DAY(SBQQ__EndDate__c)=30,((DAY(SBQQ__EndDate__c)-DAY(SBQQ__StartDate__c)+1))/30,IF(AND((DAY(SBQQ__EndDate__c)<DAY(SBQQ__StartDate__c)),DAY(SBQQ__StartDate__c)=31),((DAY(SBQQ__EndDate__c)-DAY(SBQQ__StartDate__c))+2)/30*-1,IF(DAY(SBQQ__EndDate__c)<DAY(SBQQ__StartDate__c),((DAY(SBQQ__EndDate__c)+1-DAY(SBQQ__StartDate__c)))/30*-1,IF(DAY(SBQQ__StartDate__c)=1,((DAY(SBQQ__EndDate__c)-DAY(SBQQ__StartDate__c)+1))/30,((DAY(SBQQ__EndDate__c)-DAY(SBQQ__StartDate__c))+1)/30)))))))))))+((YEAR(SBQQ__EndDate__c)-YEAR(SBQQ__StartDate__c)-1)*12)+(12-MONTH(SBQQ__StartDate__c)+MONTH(SBQQ__EndDate__c))
Write an answer...
0/9000