Hey guys,
I have a question regarding the following problem:
The current input table looks like this in which the weekend days' amount remains the same:
| Date | Amount |
| 2021-01-04 | 4 |
| 2021-01-05 | 5 |
| 2021-01-06 | 6 |
| 2021-01-07 | 7 |
| 2021-01-08 | 8 |
| 2021-01-09 | 8 |
| 2021-01-10 | 8 |
| 2021-01-11 | 9 |
| 2021-01-12 | 10 |
However, I would like to have the following logic into it so that the "weekend days' amount" becomes the Monday amount, say "Monday=4" becomes "Monday=1"; and Tuesdays becomes Monday, say "Tuesday=5" now becomes "Tuesday=4". The following table should illustrate it better:
| Day | Date | Amount |
| Monday | 2021-01-04 | ... |
| Tuesday | 2021-01-05 | 4 |
| Wednesday | 2021-01-06 | 5 |
| Thursday | 2021-01-07 | 6 |
| Friday | 2021-01-08 | 7 |
| Saturday | 2021-01-09 | 7 |
| Sunday | 2021-01-10 | 7 |
| Monday | 2021-01-11 | 8 |
| Tuesday | 2021-01-12 | 9 |
Does that makes sense? Cheers for your replies! 🙂
Julian
