I have a SharePoint list with a priority level column and a due date column. I successfully created a calculated formula in the due date column to calculate the due date from the date of creation however I have realised that the days being calculated should be working/business days and not include weekends. I've tried several different formulas but can't seem to get it right.
=IF(Priority="(Brief) Non-Urgent",Created+21,IF(Priority="(Brief) Urgent",Created+5,IF(Priority="(Corro) Standard",Created+28,IF(Priority="(Corro) Special",Created+5,IF(Priority="(Corro) Response",Created+10,Created)))))