+ Start a Discussion
domdickdomdick 

Help on the formula date field

Hello,

I have following formula that works fine if the start date is 01/10/2013 and terms_month is 3 then it gives me the result on end date 31/12/2013

But the business prospective we need to add additional day on the end date so the results would auto calculate end date to 01/01/2014.

Any idea with an example???

formula so far:
DATE(Year(start_date__c)+ floor((MONTH(start_date__c) + term_months__c -1) / 12) ,
mod(MONTH(start_date__c) + term_months__c-1, 12) + 1 ,
day(start_date__c)) - 1

PrabhaPrabha
+1 is what you need.
(DATE(Year(start_date__c)+ floor((MONTH(start_date__c) + term_months__c -1) / 12) ,
mod(MONTH(start_date__c) + term_months__c-1, 12) + 1 ,
day(start_date__c)) - 1)+1
PrabhaPrabha
or

DATE(Year(start_date__c)+ floor((MONTH(start_date__c) + term_months__c -1) / 12) ,
mod(MONTH(start_date__c) + term_months__c-1, 12) + 1 ,
day(start_date__c))

I just took '-1' out from your formula...