Vote 3490  Points

Need the ability to add and subtract months and years in formula fields.

Applications, Sales Force Automation, Financial Services, Industry Solutions, Large Enterprise Ideas, Large Enterprise

Product Team Review

Currently we can add days to a date however we can not add months in custom formula fields. The closest accuracy we could get would be to add 30 days per month to the date. Unfortunately "close enough" this is not acceptable in business when it comes to things like contract expiration dates. Years would be feasible yet cumbersome to add using the DATE and YEAR functions but I'm not able to come up with any ways to properly increase dates by months.

7 years ago · 80 Comments ·Merge Idea · Report Abuse

1 to 10 of 80 | Next Page



from AppExchange


Help us to keep IdeaExchange clean by pointing out overlapping ideas. We'll investigate your suggestion and merge the ideas if it makes sense.



Thanks for your merge suggestion. We will review it shortly and merge the ideas if applicable. takes abuse situations very seriously. Examples of abuse include but are not limited to posting of offensive language or fraudulent statements. To help us process your request as quickly as possible, please fill out the form below describing the situation. For privacy and security reasons, the final outcome of an abuse case may not be revealed to the person who reported it.


Thank you for your feedback. We take abuse seriously and will investigate this issue and take appropriate action.