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|
Thanks in advance.