Hello~
This is my first post and I'm new to the Power Platform community. I need some assistance with the most efficient way and most appropriate application to calculate an "expected due date" SharePoint list column.
Here is the business scenario:
I have 2 questions related to this problem:
I've experimented some with the following, using =IF(Weekday) formula, but not sure if I'm on the right track or if there is a cleaner, easier way. I'm struggling with out to test the Document SLA in this formula.
=IF(Weekday([Request Date],>1,[Request Date]+7, IF(Weekday([Request Date])>6,[Request Date]+9, [Request Date]+8))
Request Date | Weekday | Days to Add (for documents with 5 business day SLA) | SLA Due Day |
Sunday | 1 | +8 | Monday |
Monday | 2 | +7 | Monday |
Tuesday | 3 | +7 | Tuesday |
Wednesday | 4 | +7 | Wednesday |
Thursday | 5 | +7 | Thursday |
Friday | 6 | +7 | Friday |
Saturday | 7 | +9 | Monday |
I appreciate any insight the community can offer on this problem!
User | Count |
---|---|
256 | |
107 | |
90 | |
51 | |
44 |