function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
KJLKJL 

Inability to add Months onto an existing date

If I have a field that lets someone enter a start date, and another field that lets someone enter total #of months on a project, how can I make it so my custom field displays the end date of the project based on this information?  I can't come up with a formula that is under 5k characters (I have gotten down to about 5210).
 
Here is the formula i tried last.
 

DATE(YEAR( SD__c )+FLOOR((MONTH(SD__c )+  TotalC__c  )/12),( (MONTH(SD__c )-((FLOOR(((TotalC__c )+YEAR(SD__c ))/12)*12)-TotalC__c ))),DAY(SD__c ))

 

SD = start date.  TotalC is the total length of contract.

 

Thanks for any help!

03-13-200701:01 PM  
PaulchampioPaulchampio
Hi, i've got the same requriement to add the number of months to a date. Did you find out how to do it?
HerosHeros
I had the same problem then I created the following:

Plan_Start_Date__c + (Months_for_Plan__c*30.445)
edonaedona
I am having the same problem. Did anyone come up with a formula for this? The formula above is not working.