I have a standard object with some customer fields.
I have one custom field, complaint received date, when the user will select the date themselves.
I then have 2 fields which need formula input on:
-acknowledgement due field = complaint received date field + 3 working days
-response due field= complaint received date field + 8 weeks
Would anyone be able to help with the formula for these fields? I'm completely stuck!
Thanks!
8 risposte
Eric Praud (Activ8 Solar Energies) 
Forum Ambassador
Hi Ashley,
Create formula fields returning dates like so:acknowledgement due field:
IF(ISBLANK(complaint_received_date__c),NULL,
complaint_received_date__c+
CASE(WEEKDAY(complaint_received_date__c),1,3,2,3,3,3,7,4,5))
response due field:
complaint_received_date__c+56
