I have a formula field (date type) to calculate a date that is 9 months in the future based on the issued_date__c (date type).
DATE ( YEAR(issued_date__c), MONTH(issued_date__c)+9, DAY(issued_date__c) )
This has failed completely if the month is April onward because there is no such thing as month 13.
Has anyone got a solution?
Thanks in advance,