/ Published in: Other
Expand |
Embed | Plain Text
Copy this code and paste it in your HTML
IF(DAY(Start_Date__c) >1, DATE(YEAR(Start_Date__c + (365/12)*Membership_term_Months__c), (IF((MONTH(Start_Date__c + (365/12)*Membership_term_Months__c)+2)>12,(MONTH(Start_Date__c + (365/12)*Membership_term_Months__c)+2)-12, (MONTH(Start_Date__c + (365/12)*Membership_term_Months__c)+2))) , 1), DATE(YEAR(Start_Date__c+(365/12)*Membership_term_Months__c), (IF((MONTH(Start_Date__c + (365/12)*Membership_term_Months__c)+1)>12,(MONTH(Start_Date__c + (365/12)*Membership_term_Months__c)+1)-12, (MONTH(Start_Date__c + (365/12)*Membership_term_Months__c)+1))),1))