Hi all,

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,

S