Calculating similar information/values as per two different dates

Dear experts,

Again I am in need of a solution for the following requirement. Hope you would give me your valuable support in this regard too.

Description about the situation

I have attached here an excel sheet which has a sheet tab called "Master sheet" and another called "Advanced Production Summary". The Advanced production summary already includes the planned production as per the master sheet( I didn't delete formulas as I though they would help in the new requirement).

The new situation is like this;
There are occasions that we do "advanced production" by pulling out quantities from "future dates" to date. This normally happens due to filling the current gaps in factory production lines.

However, due to this, I have to "reduce" the "advanced produced quantities" from "future dates" to see the "actual quantities" that are left for the future dates and "re allocate" quantities to fill the planned capacity in the future dates(weeks/months)

As a solution, I have put a remark column(AA) to mention the "situation" and the "production completed date"(AB). Now I want to show these quantities as per their "original dates" as per the date in the column P of the master sheet, and "completion date" as per the date in the col AB in the master sheet.

In other words, "the same quantity" will appear in two different months based on their "Original Cut off date"(col P), and "Advance Production Completion Date"(AB). It is also essential to show the "Advanced Completed Quantities" in RED FONT colour.

Can there be a formula solution for this? If showing this situation in the same sheet is difficult, it is okay to use two sheets and "generate a summary sheet"

Regards
Anuruddha