I have a calculated column titled Due Date that pulls from 2 columns: 'Priority' and 'Date added'. Formula:
FYI, the priority column is populated with days allowed for the task to be completed (ie, 10 business days, 20 business days, etc), so the formula works fine to output a real due date--I just had to adjust those priority levels that are in multiple of 5's to include weekends (ie, 10 business days changed to 14 days, 20 business days was changed to 28 days, within my Priority column). The problem is: I have two priority levels that are not in multiple of 5's, those priority levels are due in 1 day and 3 day, respectively. Question: is there a formula that will encompass all of that? Recognize that IF 'priority'=1 OR 'Priority'=3 AND IF 'Date added' is a weekday>5 OR weekday>3, respectively, then 2 additional days need to be added to the output...otherwise
=[Date added]+[Priority] is used to calculate all other priorities>3?