question

SarahKapelleWorkSafe-7464 avatar image
0 Votes"
SarahKapelleWorkSafe-7464 asked ElsieLu-MSFT answered

Calculate a due date based on priority excluding weekends

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

office-sharepoint-online
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

I'm looking into your issue now and I will reply you as soon as possible.
Thanks for your understanding and patience.

1 Vote 1 ·

1 Answer

ElsieLu-MSFT avatar image
0 Votes"
ElsieLu-MSFT answered

Hi @SarahKapelleWorkSafe-7464 ,

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.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.