I need a formula that can actively change a target number day by day to compensate based on whether I exceeded/failed to reach the target from the previous day.
E.g. My target is 45 every day for 20 days. If I only achieve 30 in a day, the rest of the days must increase to allow me to compensate.
Solved by S. U. in 21 mins