Hello
I am trying to put together a global change formula that allows me to reduce the remaining duration of activities by a prescribed number of days (in this case the reporting period)
This formula needs to also recognise that any remaining duration needs to have a bare minimum of 1 day.
Basically I have a large schedule that would benefit from this ‘quick fix’ global change after the data date has moved to the right, save me having to go through activities line by line making manual adjustments.
I did used to have this handy formula written down but I can’t find it :-(
Any help?
Many thanks