Spreadsheet: 803001d1667212785-to-calculate-summary-of-total-qty-based-on-leadtime-copy-of-copy1-of-example-of-coloring-and-formulas-to-counting-the-input-date-within-the-lt
Sheet: Sheet1

 |  |  |  |  |  |  | I need those Date within ETA of November (Considering LT but ignoring the holidays) are in some color background without value as I need to input manually later on
 |  |  |  |  |  | Daily Allocation |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Nov ETA Plan |  |  |  |  |  | Nov Actual Allocation (ETA) |  |  |  |  |  | Nov Remain Allocation
SOURCE | MATERIAL | Branch | PG | MODEL CODE | LT | W42 | W42 | W43 | W43 | W43 | W43 | W43 | W43 | W43 | W44 | W44 | W44 | W44 | W44 | W44 | W44 | W45 | W45 | W45 | W45 | W45 | W45 | W45 | W46 | W46 | W46 | W46 | W46 | W46 | W46 | W47 | W47 | W47 | W47 | W47 | W47 | W47 | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | W45 | W46 | W47 | [NAME] | [NAME] | Nov Total | W45 | W46 | W47 | [NAME] | [NAME] | Nov Total | W45 | W46 | W47 | [NAME] | [NAME] | Nov Total
 |  |  |  |  |  | 2022-10-15 00:00:00 | 2022-10-16 00:00:00 | 2022-10-17 00:00:00 | 2022-10-18 00:00:00 | 2022-10-19 00:00:00 | 2022-10-20 00:00:00 | 2022-10-21 00:00:00 | 2022-10-22 00:00:00 | 2022-10-23 00:00:00 | 2022-10-24 00:00:00 | 2022-10-25 00:00:00 | 2022-10-26 00:00:00 | 2022-10-27 00:00:00 | 2022-10-28 00:00:00 | 2022-10-29 00:00:00 | 2022-10-30 00:00:00 | 2022-10-31 00:00:00 | 2022-11-01 00:00:00 | 2022-11-02 00:00:00 | 2022-11-03 00:00:00 | 2022-11-04 00:00:00 | 2022-11-05 00:00:00 | 2022-11-06 00:00:00 | 2022-11-07 00:00:00 | 2022-11-08 00:00:00 | 2022-11-09 00:00:00 | 2022-11-10 00:00:00 | 2022-11-11 00:00:00 | 2022-11-12 00:00:00 | 2022-11-13 00:00:00 | 2022-11-14 00:00:00 | 2022-11-15 00:00:00 | 2022-11-16 00:00:00 | 2022-11-17 00:00:00 | 2022-11-18 00:00:00 | 2022-11-19 00:00:00 | 2022-11-20 00:00:00 | 2022-11-21 00:00:00 | 2022-11-22 00:00:00 | 2022-11-23 00:00:00 | 2022-11-24 00:00:00 | 2022-11-25 00:00:00 | 2022-11-26 00:00:00 | 2022-11-27 00:00:00 | 2022-11-28 00:00:00 | 2022-11-29 00:00:00 | 2022-11-30 00:00:00 | 2022-11-01 00:00:00 | 2022-11-07 00:00:00 | ######## | ######## | ######## |  | 2022-11-01 00:00:00 | 2022-11-07 00:00:00 | 2022-11-14 00:00:00 | 2022-11-21 00:00:00 | 2022-11-28 00:00:00 |  | 2022-11-01 00:00:00 | 2022-11-07 00:00:00 | 2022-11-14 00:00:00 | 2022-11-21 00:00:00 | 2022-11-28 00:00:00
HEI | AA86T0ERW | DPS | CAC | ABCDE | 5 |  |  |  |  |  |  |  |  |  |  |  |  | 10 | 15 |  |  |  | 10 | 15 | 10 | 15 |  |  |  |  | 10 | 15 |  |  |  | 10 | 15 | 10 | 15 |  |  |  | 10 | 15 |  | 10 | 15 |  |  |  |  |  |  |  |  |  |  | 0
HEI | AA86T0ERW | BDG | CAC | ABCDE | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10 | 15 |  |  | 10 | 15 |  | 10 | 15 |  |  | 10 | 15 |  |  | 10 | 15 |  |  | 10 | 15 |  |  | 10 | 15 |  |  |  | 10 | 15 |  |  |  |  |  |  | 0
HEI | AA86T0ERW | CRB | CAC | ABCDE | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
HEI | AA86T0ERW | JGY | CAC | ABCDE | 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 15 | 10 | 15 | 10 | 15 |  |  | 10 | 15 | 10 | 15 | 10 | 15 |  | 10 | 15 |  |  |  |  |  |  | 10 | 15 |  |  | 10 | 15
HEI | AA86T0ERW | MDN | CAC | ABCDE | 5 |  |  |  |  |  |  |  |  |  |  |  |  | 10 | 15 |  |  |  |  |  |  |  |  |  |  | 10 | 15 | 10 | 15 |  |  |  | 10 | 15 |  |  |  |  |  | 10 | 15 | 10 | 15
HEI | AA86T0ERW | MKS | CAC | ABCDE | 6 |  |  |  |  |  |  |  |  |  |  |  | 10 | 15 |  |  |  |  |  |  |  |  |  |  |  |  |  | 10 | 15 |  |  | 10 | 15
HEI | AA86T0ERW | MND | CAC | ABCDE | 14 |  |  |  | 10 | 15 | 10 | 15 |  |  | 10 | 15 |  | 10 | 15 |  |  | 10 | 15 |  | 10 | 15 |  |  | 10 | 15 |  | 10 | 15
HEI | AA86T0ERW | PKB | CAC | ABCDE | 7 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10 | 15 |  | 10 | 15 |  |  |  | 10 | 15 |  | 10 | 15 |  |  | 10 | 15 |  | 10 | 15
 |  |  |  |  |  |  | for November ETA. I gave orange color |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | EXPECTED RESULT
 |  |  |  |  |  | Daily Allocation |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Nov ETA Plan |  |  |  |  |  | Nov Actual Allocation (ETA) |  |  |  |  |  | Nov Remain Allocation
SOURCE | MATERIAL | Areas | PG | MODEL CODE | Lead Time | W42 | W42 | W43 | W43 | W43 | W43 | W43 | W43 | W43 | W44 | W44 | W44 | W44 | W44 | W44 | W44 | W45 | W45 | W45 | W45 | W45 | W45 | W45 | W46 | W46 | W46 | W46 | W46 | W46 | W46 | W47 | W47 | W47 | W47 | W47 | W47 | W47 | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | W45 | W46 | W47 | [NAME] | [NAME] | Nov Total | W45 | W46 | W47 | [NAME] | [NAME] | Nov Total | W45 | W46 | W47 | [NAME] | [NAME] | Nov Total
 |  |  |  |  |  | 2022-10-15 00:00:00 | 2022-10-16 00:00:00 | 2022-10-17 00:00:00 | 2022-10-18 00:00:00 | 2022-10-19 00:00:00 | 2022-10-20 00:00:00 | 2022-10-21 00:00:00 | 2022-10-22 00:00:00 | 2022-10-23 00:00:00 | 2022-10-24 00:00:00 | 2022-10-25 00:00:00 | 2022-10-26 00:00:00 | 2022-10-27 00:00:00 | 2022-10-28 00:00:00 | 2022-10-29 00:00:00 | 2022-10-30 00:00:00 | 2022-10-31 00:00:00 | 2022-11-01 00:00:00 | 2022-11-02 00:00:00 | 2022-11-03 00:00:00 | 2022-11-04 00:00:00 | 2022-11-05 00:00:00 | 2022-11-06 00:00:00 | 2022-11-07 00:00:00 | 2022-11-08 00:00:00 | 2022-11-09 00:00:00 | 2022-11-10 00:00:00 | 2022-11-11 00:00:00 | 2022-11-12 00:00:00 | 2022-11-13 00:00:00 | 2022-11-14 00:00:00 | 2022-11-15 00:00:00 | 2022-11-16 00:00:00 | 2022-11-17 00:00:00 | 2022-11-18 00:00:00 | 2022-11-19 00:00:00 | 2022-11-20 00:00:00 | 2022-11-21 00:00:00 | 2022-11-22 00:00:00 | 2022-11-23 00:00:00 | 2022-11-24 00:00:00 | 2022-11-25 00:00:00 | 2022-11-26 00:00:00 | 2022-11-27 00:00:00 | 2022-11-28 00:00:00 | 2022-11-29 00:00:00 | 2022-11-30 00:00:00 | 2022-11-01 00:00:00 | 2022-11-07 00:00:00 | ######## | ######## | ######## |  | 2022-11-01 00:00:00 | 2022-11-07 00:00:00 | 2022-11-14 00:00:00 | 2022-11-21 00:00:00 | 2022-11-28 00:00:00 |  | 2022-11-01 00:00:00 | 2022-11-07 00:00:00 | 2022-11-14 00:00:00 | 2022-11-21 00:00:00 | 2022-11-28 00:00:00
HEI | AA86T0ERW | DPS | CAC | ABCDE | 5 |  |  |  |  |  |  |  |  |  |  |  |  | 10 | 15 |  |  |  | 10 | 15 | 10 | 15 |  |  |  |  | 10 | 15 |  |  |  | 10 | 15 | 10 | 15 |  |  |  | 10 | 15 |  | 10 | 15 |  |  |  |  | 12
HEI | AA86T0ERW | BDG | CAC | ABCDE | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10 | 15 |  |  | 10 |  |  | 10 | 15 |  |  | 10 |  |  |  | 10 | 15 |  |  |  |  |  |  | 10 | 15 |  |  |  | 10 | 15 | 12
HEI | AA86T0ERW | CRB | CAC | ABCDE | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 12
HEI | AA86T0ERW | JGY | CAC | ABCDE | 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 15 | 10 | 15 | 10 | 15 |  |  | 10 | 15 | 10 | 15 | 10 |  |  | 10 | 15 |  |  |  |  |  |  | 10 | 15 |  |  |  |  |  |  | 12
HEI | AA86T0ERW | MDN | CAC | ABCDE | 5 |  |  |  |  |  |  |  |  |  |  |  |  | 10 | 15 |  |  |  |  |  |  |  |  |  |  | 10 | 15 | 10 | 15 |  |  |  | 10 | 15 |  |  |  |  |  | 10 | 15 | 10 | 15 |  |  |  |  | 12
HEI | AA86T0ERW | MKS | CAC | ABCDE | 6 |  |  |  |  |  |  |  |  |  |  |  | 10 | 15 |  |  |  |  |  |  |  |  |  |  |  |  |  | 10 | 15 |  |  | 10 | 15 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 12
HEI | AA86T0ERW | MND | CAC | ABCDE | 14 |  |  |  | 10 | 15 | 10 | 15 |  |  | 10 | 15 |  | 10 | 15 |  |  | 10 | 15 |  | 10 | 15 |  |  | 10 | 15 |  | 10 | 15 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 12
HEI | AA86T0ERW | PKB | CAC | ABCDE | 7 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10 | 15 |  | 10 | 15 |  |  |  | 10 | 15 |  | 10 |  |  |  | 10 | 15 |  | 10 |  |  |  |  |  |  |  |  |  |  |  | 12