Good day,
I hope you find this message well. I am hoping to get some of your help to finally finish my workflow. I am working with the due dates and will give each prioritization depends on its date (Due Date) and marked as '1' '2' and '3'. if the due date is 1 day from as of date then it will marked as '3' then 2 days from as of date would be '2', so on and so forth.
I already have a formula below however, my problem is the exclusion of non-working days, particularly Sunday and Saturday. For instance, if I have a due date of 04/18/2025, which falls on a Friday, the following days are Sunday and Saturday. In this example workflow, it would automatically be classified as priority 1. However, it should actually be priority 3, considering my assigned date is today's date, 04/21/2025, excluding Sunday and Saturday, resulting in only 1 working day.
Formula:
IF DateTimeDiff([Date Assigned],[Due Date],'days') <2
THEN 3
ELSEIF DateTimeDiff([Date Assigned],[Due Date],'days') =2
THEN 2
ELSE 1
ENDIF
Below is the final output that I want to be achieve.
Assigned Date Due Date Prioritization
4/17/2025 4/17/2025 3
4/17/2025 4/16/2025 3
4/17/2025 4/15/2025 2
4/17/2025 4/14/2025 1
4/17/2025 4/13/2025 1
4/17/2025 4/12/2025 1
4/17/2025 4/11/2025 1
4/17/2025 4/10/2025 1
Hope someone will help me re on this problem, best and regards.
