Hello,
I'm trying to write a formula that will result in one of three calculations on a date:

• if the orignial start date and CO (Change Order) license term months fields are populated, then ADDMONTHS to orignial start date, otherwise null; or
• If the CO start date and original license term months fields are populated, then ADDMONTHS to the CO start date, otherwise null; or
• If the CO start date and CO license term months are populated, then ADDMONTHS to the CO start date, otherwise null.

Basically I'm hoping that one of the three scenarios will populate a field with an updated date. I'm getting an error with the following formula that I'm using the incorrect parameter type for or(), expected boolean, recevied date. I've been working on this for a few days and just can't seem to figure out what I'm doing wrong; any feedback would be appreciated. Thank you!

IF ( ISBLANK( CO_Start_Date__c ) 
|| ISBLANK( Original_License_Term_Months__c ) , NULL,
 ADDMONTHS(CO_Start_Date__c, Original_License_Term_Months__c)),

IF ( ISBLANK( Original_Start_Date__c ) 
|| ISBLANK( CO_License_Term_Months__c ) , NULL,
 ADDMONTHS(Original_Start_Date__c, CO_License_Term_Months__c)),

IF ( ISBLANK( CO_Start_Date__c ) 
|| ISBLANK( CO_License_Term_Months__c ) , NULL,
 ADDMONTHS(CO_Start_Date__c, CO_License_Term_Months__c))

 

Hello

I have been directed here for some help from Answers 

I am looking for help creating a button that sits in the list view of both Accounts and Contacts that allows me to change owner on both objects simultaneously regardless of the object list view I in. 

I have been advised I need to write a VF page but I'm afraid I am not a developer. 

Can anyone help or who use such a function? Appreciate in advance. 

Marc