In a Formula Field;
I tried to add a month to the date and subtract some other date value as follows but the formula returns me "#Error!" in the UI
DATE( YEAR( reportDueDate__c ), ( MONTH( reportDueDate__c )+1 ) , DAY( reportDueDate__c) ) -
DATE( YEAR( reportDate__c ) , MONTH( reportDate__c ), DAY( reportDate__c) )
How could this adding 1 month cause an error? ( MONTH( reportDueDate__c )+1 )
Please help. Thanks in advance