• Paulchampio
  • NEWBIE
  • 0 Points
  • Member since 2007

  • Chatter
    Feed
  • 0
    Best Answers
  • 0
    Likes Received
  • 0
    Likes Given
  • 0
    Questions
  • 1
    Replies
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  
  • March 14, 2007
  • Like
  • 0