Date Time Function - Prioritization Base on Due Date

[Franzil]

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.

[Qiu · Accepted solution]

@Franzil 
I would use the Generate Rows to generate the date between Assign and Due Dates then exclude the Weekends.

[Franzil]

Good day Sir @Qiu , Sorry for the late revert since I am really busy with my work. This is really a great idea and yes this worked on my end. Thank you so much for helping me on this. Godspeed!

[Qiu]

Glad it helps.

[Franzil]

Thank you again Sir.