Spreadsheet: 788574d1658556259-bifurcate-the-amount-as-per-date-day-difference-duty-exemption
Sheet: Sheet1

 |  |  |  |  |  | Calculation 1 (of Cell C7 & Cell D7) |  |  |  |  | Calculation 2 (of Cell D11) |  |  |  |  | Calculation 3 (of [NAME])
 | Duty Amount | Debit | Credit | Duty Date |  |  |  |  | 2019-07-20 00:00:00 |  |  |  |  | 2019-11-15 00:00:00 |  |  |  |  | 2020-09-19 00:00:00
 | 2028.59 | 2028.59 |  | 2019-04-18 00:00:00 |  |  |  |  | 2019-07-21 00:00:00 |  |  |  |  | 2019-11-16 00:00:00 |  |  |  |  | 2020-09-20 00:00:00
 | 7514.71 | 7514.71 |  | 2019-05-18 00:00:00 |  |  |  |  | 2019-07-22 00:00:00 |  |  |  |  | 2019-11-17 00:00:00 |  |  |  |  | 2020-09-21 00:00:00
 | 8983.9 | 8983.9 |  | 2019-06-20 00:00:00 |  |  |  |  | 2019-07-23 00:00:00 |  |  |  |  | 2019-11-18 00:00:00 |  |  |  |  | 2020-09-22 00:00:00
 | 13777.19 | 13777.19 |  | 2019-07-20 00:00:00 |  |  |  |  | 2019-07-24 00:00:00 |  |  |  |  | 2019-11-19 00:00:00 |  |  |  |  | 2020-09-23 00:00:00
 | 10017.56 | 7613.345599999999 | 2404.2144 | 2019-08-14 00:00:00 |  |  |  |  | 2019-07-25 00:00:00 |  |  |  |  | 2019-11-20 00:00:00 |  |  |  |  | 2020-09-24 00:00:00
 | 12514.5 |  |  | 2019-09-13 00:00:00 |  |  | This is the Calculation for Cell C7 | This is the Calculation for Cell D7 | 2019-07-26 00:00:00 |  |  |  | This is the Calculation for Cell D11 | 2019-11-21 00:00:00 |  |  | This is the Calculation for Cell D19 |  | 2020-09-25 00:00:00
 | 16125.19 |  |  | 2019-10-18 00:00:00 |  |  |  |  | 2019-07-27 00:00:00 |  |  |  |  | 2019-11-22 00:00:00 |  |  |  |  | 2020-09-26 00:00:00
 | 12128.63 |  |  | 2019-11-15 00:00:00 |  |  |  |  | 2019-07-28 00:00:00 |  |  |  |  | 2019-11-23 00:00:00 |  |  |  |  | 2020-09-27 00:00:00
 | 11580.19 |  | 5376.516785714286 | 2019-12-13 00:00:00 |  |  |  |  | 2019-07-29 00:00:00 |  |  |  |  | 2019-11-24 00:00:00 |  |  |  |  | 2020-09-28 00:00:00
 | 15710.72 |  | 15710.72 | 2020-01-20 00:00:00 |  |  |  |  | 2019-07-30 00:00:00 |  |  |  |  | 2019-11-25 00:00:00 |  |  |  |  | 2020-09-29 00:00:00
 | 9687.69 |  | 9687.69 | 2020-02-13 00:00:00 |  |  |  |  | 2019-07-31 00:00:00 |  |  |  |  | 2019-11-26 00:00:00 |  |  |  |  | 2020-09-30 00:00:00
 | 13626.72 |  | 13626.72 | 2020-03-17 00:00:00 |  |  |  |  | 2019-08-01 00:00:00 |  |  |  |  | 2019-11-27 00:00:00 |  |  |  |  | 2020-10-01 00:00:00
 | 17517.93 |  | 17517.93 | 2020-05-22 00:00:00 |  |  |  |  | 2019-08-02 00:00:00 |  |  |  |  | 2019-11-28 00:00:00 |  |  |  |  | 2020-10-02 00:00:00
 | 12616.13 |  | 12616.13 | 2020-07-11 00:00:00 |  |  |  |  | 2019-08-03 00:00:00 |  |  |  |  | 2019-11-29 00:00:00 |  |  |  |  | 2020-10-03 00:00:00
 | 10595 |  | 10595 | 2020-08-13 00:00:00 |  |  |  |  | 2019-08-04 00:00:00 |  |  |  |  | 2019-11-30 00:00:00 |  |  |  |  | 2020-10-04 00:00:00
 | 12114.33 |  | 12114.33 | 2020-09-19 00:00:00 |  |  |  |  | 2019-08-05 00:00:00 |  |  |  |  | 2019-12-01 00:00:00 |  |  |  |  | 2020-10-05 00:00:00
 | 8298.93 |  | 3830.275384615385 | 2020-10-15 00:00:00 |  |  |  |  | 2019-08-06 00:00:00 |  |  |  |  | 2019-12-02 00:00:00 |  |  |  |  | 2020-10-06 00:00:00
 |  |  |  |  |  |  |  |  | 2019-08-07 00:00:00 |  |  |  |  | 2019-12-03 00:00:00 |  |  |  |  | 2020-10-07 00:00:00
Extra Duty Collection Date From | 2019-04-01 00:00:00 | To | 2019-08-08 00:00:00 |  |  |  |  |  | 2019-08-08 00:00:00 |  |  |  |  | 2019-12-04 00:00:00 |  |  |  |  | 2020-10-08 00:00:00
Duty Relief Date From | 2019-12-01 00:00:00 | To | 2020-10-01 00:00:00 |  |  |  |  |  | 2019-08-09 00:00:00 |  |  |  |  | 2019-12-05 00:00:00 |  |  |  |  | 2020-10-09 00:00:00
 |  |  |  |  |  |  |  |  | 2019-08-10 00:00:00 |  |  |  |  | 2019-12-06 00:00:00 |  |  |  |  | 2020-10-10 00:00:00
I EXPECT THE RESULTS SHOW AS PER COLUMN C (CELL C3:C19) AND COLUMN D (CELL D3:[NAME]) WITHOUT DOING CALCULATIONS 1, 2 AND 3 BY USING FORMULA. |  |  |  |  |  |  |  |  | 2019-08-11 00:00:00 |  |  |  |  | 2019-12-07 00:00:00 |  |  |  |  | 2020-10-11 00:00:00
 |  |  |  |  |  |  |  |  | 2019-08-12 00:00:00 |  |  |  |  | 2019-12-08 00:00:00 |  |  |  |  | 2020-10-12 00:00:00
 |  |  |  |  |  |  |  |  | 2019-08-13 00:00:00 |  |  |  |  | 2019-12-09 00:00:00 |  |  |  |  | 2020-10-13 00:00:00
 |  |  |  |  |  |  |  |  | 2019-08-14 00:00:00 |  |  |  |  | 2019-12-10 00:00:00 |  |  |  |  | 2020-10-14 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2019-12-11 00:00:00 |  |  |  |  | 2020-10-15 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2019-12-12 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2019-12-13 00:00:00