Spreadsheet: 125467d1319047213-using-a-formula-to-copy-a-cell-if-another-cells-value-is-between-two-dates-dummie-master-schedule
Sheet: Sheet1

[NAME] | PO_STATUS | YEAR | MONTH | CAT | CUSTOMER | PURCHASE ORDER# | LINE | ITEM# | [NAME] | QTY | SHOP ORDER | SALES ORDER | ORIGINAL DUE DATE | PROMISE DATE | NEW NEED BY DATE | SHIP BY DATE | FPQ | MAKE | BUY | STATUS | MATL # | DUE DATE | DELIVERY | IFT | PROJ. ONTIME | COMMENTS | 10 | 20 | 30 | 40 | 50 | 60 | 70 | 80 | 90 | 100 | SHIP DATE | INDEX
 |  |  |  | S | GE SCHDY | 600066619 | 1 | 102T3109 | T835 DEVIATED MID A | 3 | 5581 | S3889 | 2011-10-12 00:00:00 | 2011-10-12 00:00:00 |  |  |  |  |  |  | 501140 | 2011-10-28 00:00:00
 |  |  |  | S | GE SCHDY | 600066555 | 1 | 0659A908P0024 | SILVER SOLDER | 250 | S3864 | S3864 | 2011-10-24 00:00:00 | 2011-10-24 00:00:00
 |  |  |  | L | DRESSER RAND | 100009607 | 1 | 421-597-201 | LABYRINTH SEAL INTAKE | 1 | 5582 | S3865 | 2011-10-28 00:00:00 | 2011-10-28 00:00:00 |  |  |  |  |  |  | CSM-000-012-018, 090-351-111 | 2011-10-14 00:00:00 |  |  |  |  |  |  |  | SMGAP | V MILL | BP | FI | SHIP
 |  |  |  | S | DRESSER RAND | 100009716 | 1 | 123-979-004 | BLOCK ADJUSTING SLIDE | 2 | 5583 | S3891 | 2011-10-28 00:00:00 | 2011-10-28 00:00:00 |  |  |  |  |  | H MILL | 501141 | 2011-10-14 00:00:00
 |  |  |  | D | GE ATLANTA | 423353189 | 1 | 04844362G0078 | OIL [NAME] | 1 | 5586 | S3874 | 2011-10-28 00:00:00 | 2011-10-28 00:00:00 |  |  |  |  |  | KT | 501139 | 2011-10-12 00:00:00
 |  |  |  | S | DRESSER RAND | 100009928-1 | 1 | 478-140-001 | BLOCK | 6 |  | S3927 | 2011-10-28 00:00:00 | 2011-10-28 00:00:00
 |  |  |  | S | DRESSER RAND | 100009928-2 | 2 | 478-140-001 | BLOCK | 6 |  | S3927 | 2011-10-28 00:00:00 | 2011-10-28 00:00:00
 |  |  |  | S | GE ENERGY | 125918238 | 1 | 102T0777P003 | SUPPORT BLOCK ASSY AND DETAILS | 58 |  | S3929 | 2011-10-28 00:00:00 | 2011-10-28 00:00:00
 |  |  |  | S | GE HYDR0 | 125915326 | 1 | 229D2105P007 | [NAME] | 180 | 4513 | S3024 | 2011-09-30 00:00:00 | 2011-10-30 00:00:00 |  |  |  |  |  |  | 500988 | 2011-05-13 00:00:00
 |  |  |  | S | GE HYDR0 | 125915326 | 2 | 229D2105P008 | [NAME] | 120 | 4514 | S3024 | 2011-09-30 00:00:00 | 2011-10-30 00:00:00 |  |  |  |  |  |  | 500989 | 2011-05-13 00:00:00
 |  |  |  | S | GE HYDR0 | 125915326 | 3 | 229D2113G001 | SHORTING RING, SEGMENT ASSY | 119 | 4515 | S3024 | 2011-09-30 00:00:00 | 2011-10-30 00:00:00 |  |  |  |  |  |  | 300366 | 2011-05-04 00:00:00 |  |  |  |  |  |  |  |  |  |  | SHIP
 |  |  |  | S | GE HYDR0 | 125915326 | 4 | 229D2106P012 | SHORTING RING, SEGMENT ASSY | 120 | 4516 | S3024 | 2011-09-30 00:00:00 | 2011-10-30 00:00:00 |  |  |  |  |  | V MILL | 500990 | 2011-05-20 00:00:00 |  |  |  |  |  |  |  |  | SHIP
 |  |  |  | S | GE HYDR0 | 125915326 | 5 | 229D2108P013 | [NAME] | 360 | 4517 | S3024 | 2011-09-30 00:00:00 | 2011-10-30 00:00:00 |  |  |  |  |  |  | 300366, 300365 | 5/4, 5/20
 |  |  |  | S | GE HYDR0 | 125915326 | 6 | 154C5045P010 | KEEPER RING | 606 | 4518 | S3024 | 2011-09-30 00:00:00 | 2011-10-30 00:00:00 |  |  |  |  |  |  | 300364 | 2011-05-13 00:00:00
 |  |  |  | L | DRESSER RAND | 100008158 | 1 | 422-523-001 | LABY INLET GUIDE | 3 | 5407 | S3715 | 2011-11-01 00:00:00 | 2011-11-01 00:00:00 |  |  |  |  |  |  | 090-351-111 |  |  |  |  |  |  |  |  |  | FI | SHIP
 |  |  |  | L | DRESSER RAND | 100008163 | 1 | 422-524-003 | LABY INLET GUIDE | 2 | 5408 | S3718 | 2011-11-01 00:00:00 | 2011-11-01 00:00:00 |  |  |  |  |  |  | 090-351-108
 |  |  |  | L | DRESSER RAND | 100008172 | 1 | 422-646-001 | LABY SHAFT SEAL | 1 | 5409 | S3720 | 2011-11-01 00:00:00 | 2011-11-01 00:00:00 |  |  |  |  |  | CNC LATHE | 090-351-110 | 2011-10-03 00:00:00
 |  |  |  | L | DRESSER RAND | 100008155 | 1 | 422-524-008 | LABY INLET GUIDE | 2 | 5410 | S3711 | 2011-11-01 00:00:00 | 2011-11-01 00:00:00 |  |  |  |  |  | CNC LATHE | 690-351-116 | 2011-10-03 00:00:00 |  |  |  |  |  |  |  |  | FI | SHIP