Date Time Function - Prioritization Base on Due Date
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
Solved! Go to Solution.
- Labels:
- Date Time
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@Franzil
I would use the Generate Rows to generate the date between Assign and Due Dates then exclude the Weekends.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Glad it helps.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thank you again Sir.
