Hi all,
I am trying to make Lastworkdate work with negative increments but it does not work.Does anyone had the same problem and can shed a light on this?
For example: Take a date (22/03/2016), subtract 10 day and you get 12/03/2016. After that you apply Lastworkdate function with 1 as a parameter (Lastworkdate(12/03/2016,1) and get 14/03/2016, Monday. That's ok so far.
Now take another date (23/03/2016) and do the same calculation. The result will be the same again, as above. My problem is in here:
I want user to move a selected date either to the front or behind and with that all the subsequent dates to move together.
There's an example below to illustrate better what I would like to do.
| Original Date | Movement (forward or backward) | Date Modified |
|---|
| 22/03/2016 | -10 | 14/03/2016 |
| 23/03/2016 | -10 | 15/03/2016 |
| 24/03/2016 | -10 | 16/03/2016 |
Thanks in advance.
