Skip to main content

New answers tagged

0 votes

How to make a formula with correct difference between dates in months?

You can use a more precise method by calculating the number of days and then dividing by the average number of days per month. ROUND( ((YEAR(EndDate__c) - YEAR(EffectiveDate__c)) * 12 + ...
Tushar Jadav's user avatar
  • 2,148
0 votes

Help with date formula

I would break down this into 2 separate use cases: When Start_date__c is less than today's date we need the field value to be rolled over by 1 year i.e. 12 months When Start_date__c is greater than ...
Rohit's user avatar
  • 2,091
1 vote

Help with date formula

Below is a Formula you can use: IF( TODAY() > DATE(YEAR(TODAY()), MONTH(Contract_Start_Date__c), DAY(Contract_Start_Date__c)), DATE(YEAR(TODAY()) + 1, MONTH(Contract_Start_Date__c), DAY(...
Tushar Jadav's user avatar
  • 2,148

Top 50 recent answers are included