Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
domdick

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

Prabha
+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
Prabha
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...