I am seeking to calculate the number of days required to process a defined tonnage (2,697.030 tons in the example - B2) as from a set date (29/06/2021 in the example-C2), taking into account the maximum tonnage (Quota) for corresponding subsequent dates available in a table.
On event, on the last day, the residual amount is less than the maximum tonnage (Quota), the residual amount is expressed as a fraction of the Quota.
Ultimately, the value of Cell D2 is obtained by summing number of divisions and remainder divided by Quota for corresponding date.
Please find attached sample Excel document.
On event, on the last day, the residual amount is less than the maximum tonnage (Quota), the residual amount is expressed as a fraction of the Quota.
Ultimately, the value of Cell D2 is obtained by summing number of divisions and remainder divided by Quota for corresponding date.
Please find attached sample Excel document.