# Calculate "Due Date" in business days based on Priority Level

I have been around the world wide web and back, tons of sites and examples and cannot find a solution. I can either find one piece of the puzzle or the other but not all of it. I have tried multiple formulas but everything throws a syntax error. I'm not sure if you can nest IF(AND statements but that's what I have been trying to do for each scenario.

I need to calculate the "Due Date" (in business days) based on Priority.

• Critical - 24 business hours (1 business day)
• Rush - 48 business hours (2 business days)
• Standard - 5 business days

I figure it out, probably the long way, but it works! I created a nested statement for each separate WEEKDAY scenario/priority level.

=IF(AND(Priority="Critical",WEEKDAY(Created)>5),Created+3, IF(AND(Priority="Critical",WEEKDAY(Created)>1),Created+1, IF(AND(Priority="Critical",WEEKDAY(Created)=1),Created+2, IF(AND(Priority="Rush",WEEKDAY(Created)>4),Created+4, IF(AND(Priority="Rush",WEEKDAY(Created)>1),Created+2, IF(AND(Priority="Rush",WEEKDAY(Created)=1),Created+3, IF(AND(Priority="Standard",WEEKDAY(Created)>6),Created+9, IF(AND(Priority="Standard",WEEKDAY(Created)>1),Created+7, Created+8))))))))