Calculate a due date based on priority excluding weekends

Question

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)))))

Answer 1

Hi @SarahK ,

Per my understanding, your requirement has a lot of validations which will require recursive checking of weekends which is too complicated for the list formula, I would suggest you go to the Power Automate forum to ask if you can use MS flow to achieve this requirement.

---

If the answer is helpful, please click "Accept Answer" and upvote it.

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.