+ Start a Discussion

Date Formula Field: Calculate Current Contract End Date with Continuous Roll Over Terms

In our organization we want our contracts to have the current contract end date for continuous contracts.


Todays Date:  03/20/2012

Initial Effective Date:  1/1/2005 (date field)

Initial Terms (months):  24  (number field)

Initial Terms End Date:  12/31/2006 (formula date field)

Roll Over Terms (months):  12 (number field)

Current Contract End Date:  12/31/2012 (this is the formula date field I am trying to create)


Thank you in advance





Can you please explain how you are going to calculate the Current Contract End Date with proper example??



Well I was hoping you could tell me. Any ideas on how to make it work?