function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
Jane Marchand 2Jane Marchand 2 

Calculate Contract End Date using Term in Months

I'm trying to calculate the End Date of a Contract.
I have the Start Date and a Contract Term in Months
I need to make sure I cater for Leap Years
I also need to make sure that the End date DAY is the Start Date DAY decremented by 1.
  • Start Date 15-03-01
  • Term Months: 12
  • End Date: 15-02-28 unless it's a leap year, therefore 15-02-29
Does anyone have a formula they'd be willing to share?

sandeep sankhlasandeep sankhla
Hi Jane,

Please refer the below link and let me know if it helps..else I will guide you how to do..

Jane Marchand 2Jane Marchand 2

Thanks Sandeep,
I tried working through that formula yesterday.
I just could not figure out how to decrement the end date by 1 day
The formula provided in the link above calculates the end date as exactly the same day as the start date but I need it to be start date (day) - 1.
Any help you could give me would be gratefully appreciated




sandeep sankhlasandeep sankhla
Hi ,

In that case have you tried using -1..

I mean after all calculation we have date then that date.adddays(-1);

CHeck with addDays(-1)..and let me know if it helps..

I tried. but it's too large to use fomula field. You need to use workflow.
And I can not for some reason post the fomula.
so I post image capture.
Please excuse me if you may not understand or you feel bad with my poor English.

User-added image

Jane Marchand 2Jane Marchand 2
Thanks all  -  we ended up using a trigger to solve this