Calculate a due date based on priority excluding weekends

SarahK 21 Reputation points
2021-06-25T06:32:23.787+00:00

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

SharePoint
SharePoint
A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.
9,607 questions
{count} votes

Accepted answer
  1. Elsie Lu_MSFT 9,756 Reputation points
    2021-07-06T07:52:55.15+00:00

    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.

    0 comments No comments

0 additional answers

Sort by: Most helpful