Hi Vera, thank you for your contribution on this but I see my attempts to simplify this turned out counterproductive.
The priority index cannot be used for day number as it goes into the thousands. I do also have a additional groups that would necesitate restarting the date count, and a capacity that would potentially allow for assigning to cases to the same date.
Example:
| | | | | Desired Output |
| Case | Group | Priority-Index | Capacity | Date |
| 1 | A | 1078 | 2 | 10/1/2021 |
| 7 | A | 1096 | 2 | 10/1/2021 |
| 8 | A | 1099 | 2 | 10/4/2021 |
| 9 | A | 1102 | 2 | 10/4/2021 |
| 13 | A | 1114 | 2 | 10/5/2021 |
| 14 | A | 1117 | 2 | 10/5/2021 |
| 2 | B | 1081 | 5 | 10/1/2021 |
| 3 | B | 1084 | 5 | 10/1/2021 |
| 4 | B | 1087 | 5 | 10/1/2021 |
| 5 | B | 1090 | 5 | 10/1/2021 |
| 6 | B | 1093 | 5 | 10/1/2021 |
| 10 | B | 1105 | 5 | 10/2/2021 |
| 11 | B | 1108 | 5 | 10/2/2021 |
| 12 | B | 1111 | 5 | 10/2/2021 |
| 15 | B | 1120 | 5 | 10/2/2021 |
| 16 | B | 1123 | 5 | 10/2/2021 |
I wasn't concerned about those other pieces as there is many ways to handle them if I have a date that can be assigned based on the index.
The starting date for the table varies and is dynamic, not hard coded. The groups can be included in the table or not depending on how a formula to assign dates based on the index would work.
I know how to build the code to copy based on available capacity. The part that I am missing is the one that I thought would be easiest. Simply adding one day, to the date before when necessary. I.e. when going from 10/1/2021 to 10/02/2021.
Not sure if that helps
