I am creating a process builder to field update a date field (Requested Start Date) that should be 14 business days after the Close Date. The field I'm updating is a date field and so is the field I'm referencing in the formula.
I am receiving an error: "The formula expression is invalid: Incorrect parameter type for function 'IF()'. Expected Date, received Text"
My formula:
IF(
MOD( [Campaign_Design_Profile__c].Related_Opportunity__c.CloseDate - DATE(1900, 1, 6), 7) > 2,
[Campaign_Design_Profile__c].Related_Opportunity__c.CloseDate + 20,'',
IF(MOD( [Campaign_Design_Profile__c].Related_Opportunity__c.CloseDate - DATE(1900, 1, 6), 7) > 0,
[Campaign_Design_Profile__c].Related_Opportunity__c.CloseDate + 19,''
)
)