# Calculated column formula to exclude business days but is dependent on priority level

I have a calculated column titled Due Date that pulls from 2 columns: 'Priority' and 'Date added'. Formula:

``````=[Date added]+[Priority]
``````

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?

-