Spreadsheet: 173175d1344457108-n-a-issue-when-using-an-equation-to-give-the-latest-date-in-a-list-example1
Sheet: Sheet1

Project Number | Material Number | Description | P/O Doc. # | [NAME] | [NAME]. | [NAME] | Order Date | Req'd Date | [NAME] | Delivery Date
C.A5305.001 |  | PAINT DETAILS PER CUSTOMER SPECS | [PHONE] |  |  | 1 | 2012-07-16 00:00:00 | 2012-07-13 00:00:00 | 0 | 2012-12-31 00:00:00 |  | C.A5305.110
C.A5305.015 |  | C.A5305.015 On-Site Support | [PHONE] |  | TC 16.05.2012 | 1 | 2012-05-14 00:00:00 | 2012-07-16 00:00:00 | 0 | 2012-08-15 00:00:00 |  | C.A5305.120
C.A5305.030 | K.00003.112.56.00 | STORAGE CABINET | [PHONE] |  | bb 03.07.2012 verbal | 1 | 2012-07-02 00:00:00 | 2012-08-02 00:00:00 | 0 | 2012-08-07 00:00:00 |  | C.A5305.130
C.A5305.030 | C.05305.031.M1.00 | TORQUE MEASUREMENT | [PHONE] |  | TC 14.05.2012 | 1 | 2012-05-02 00:00:00 | 2012-08-02 00:00:00 | 0 | 2012-08-09 00:00:00 |  | C.A5305.310
C.A5305.030 | K.00003.020.61.00 | PROTECTIVE COVER | 11214981 |  | N | 1 |  | 2012-08-02 00:00:00 |  |  |  | C.A5305.320
C.A5305.030 | K.E0001.308.76.00 | LOWER HOUSING | 11215062 |  | N | 1 |  | 2012-08-02 00:00:00 |  |  |  | C.A5305.330
C.A5305.033 | K.00003.438.96.00 | LOAD CELL | [PHONE] |  | TC 10.07.2012 | 1 | 2012-06-18 00:00:00 | 2012-08-02 00:00:00 | 0 | 2012-08-09 00:00:00 |  | C.A5305.340
C.A5305.033 | K.00003.438.97.00 | LOAD CELL | [PHONE] |  | TC 10.07.2012 | 1 | 2012-06-18 00:00:00 | 2012-08-02 00:00:00 | 0 | 2012-08-09 00:00:00 |  | C.A5305.350
C.A5305.033 | K.00003.453.33.00 | LOAD CELL | [PHONE] |  | TC 10.07.2012 | 2 | 2012-06-18 00:00:00 | 2012-08-02 00:00:00 | 0 | 2012-08-09 00:00:00 |  | C.A5305.360
C.A5305.050 |  | NEW PATTERNS FOR DETAILS 1-7, 43 AND 44 | [PHONE] |  |  | 1 | 2011-11-18 00:00:00 | 2012-07-23 00:00:00 | 0 | 2012-07-20 00:00:00 |  | C.A5305.370
C.A5305.050 | C.05305.051.ST.00 | PALLET | [PHONE] |  |  | 15 | 2011-11-18 00:00:00 | 2012-07-23 00:00:00 | 5 | 2012-07-27 00:00:00 |  | C.A5305.380
C.A5305.050 | C.05305.051.ST.00 | PALLET | [PHONE] |  |  | 20 | 2011-11-18 00:00:00 | 2012-07-23 00:00:00 | 0 | 2012-07-27 00:00:00 |  | C.A5305.390
C.A5305.050 | C.05305.051.ST.00 | PALLET | [PHONE] |  |  | 20 | 2011-11-18 00:00:00 | 2012-07-23 00:00:00 | 0 | 2012-08-03 00:00:00 |  | C.A5305.400
C.A5305.050 | C.05305.051.ST.00 | PALLET | [PHONE] |  |  | 20 | 2011-11-18 00:00:00 | 2012-07-23 00:00:00 | 0 | 2012-08-10 00:00:00 |  | C.A5305.410
C.A5305.050 | C.05305.051.ST.00 | PALLET | [PHONE] |  |  | 20 | 2011-11-18 00:00:00 | 2012-07-23 00:00:00 | 0 | 2012-08-17 00:00:00 |  | C.A5305.420
C.A5305.050 | C.05305.051.ST.00 | PALLET | [PHONE] |  |  | 20 | 2011-11-18 00:00:00 | 2012-07-23 00:00:00 | 0 | 2012-08-24 00:00:00 |  | C.A5305.430
C.A5305.050 | C.05305.051.ST.00 | PALLET | [PHONE] |  |  | 20 | 2011-11-18 00:00:00 | 2012-07-23 00:00:00 | 0 | 2012-08-31 00:00:00 |  | C.A5305.440
C.A5305.050 | C.05305.051.ST.00 | PALLET | [PHONE] |  |  | 10 | 2011-11-18 00:00:00 | 2012-07-23 00:00:00 | 0 | 2012-09-07 00:00:00 |  | C.A5305.460
C.A5305.050 | C.G5305.050.01.00 | PALLET CASTING | [PHONE] |  | PV26.01.2012 | 150 | 2011-11-18 00:00:00 | 2012-09-07 00:00:00 | 105 | 2012-09-07 00:00:00 |  | C.A5305.470
C.A5305.050 | C.G5305.050.02.00 | STAND CASTING | [PHONE] |  | PV26.01.2012 | 150 | 2011-11-18 00:00:00 | 2012-09-07 00:00:00 | 115 | 2012-09-07 00:00:00 |  | C.A5305.480
C.A5305.050 | C.G5305.050.03.00 | PALLET FIXTURE CASTING | [PHONE] |  | PV26.01.2012 | 150 | 2011-11-18 00:00:00 | 2012-09-07 00:00:00 | 105 | 2012-09-07 00:00:00 |  | C.A5305.490
C.A5305.050 | C.G5305.050.04.00 | TRUNNION CASTING | [PHONE] |  | PV26.01.2012 | 150 | 2011-11-18 00:00:00 | 2012-09-07 00:00:00 | 128 | 2012-09-07 00:00:00 |  | C.A5305.510
C.A5305.050 | C.G5305.050.05.00 | PEDESTAL CASTING | [PHONE] |  | PV26.01.2012 | 150 | 2011-11-18 00:00:00 | 2012-09-07 00:00:00 | 55 | 2012-09-07 00:00:00 |  | C.A5305.520
C.A5305.050 | C.G5305.050.06.00 | POST CASTING | [PHONE] |  | PV26.01.2012 | 150 | 2011-11-18 00:00:00 | 2012-09-07 00:00:00 | 70 | 2012-09-07 00:00:00 |  | C.A5305.530
C.A5305.050 | C.G5305.050.07.00 | POST CASTING | [PHONE] |  | PV26.01.2012 | 150 | 2011-11-18 00:00:00 | 2012-09-07 00:00:00 | 62 | 2012-09-07 00:00:00 |  | C.A5305.540
C.A5305.050 | C.G5305.050.11.00 | CLAMP CASTING | [PHONE] |  | PV26.01.2012 | 300 | 2011-11-18 00:00:00 | 2012-09-07 00:00:00 | 47 | 2012-09-07 00:00:00 |  | C.A5305.550
C.A5305.075 |  | Monthly Rental - C.C5305 | [PHONE] |  |  | 1 | 2011-12-06 00:00:00 | 2006-08-08 00:00:00 | 0 | 2012-09-30 00:00:00 |  | C.A5305.560
C.A5305.099 | K.00003.138.30.00 | SOFTWARE | [PHONE] |  |  | 40 | 2012-07-20 00:00:00 | 2012-08-02 00:00:00 | 0 | 2012-08-02 00:00:00 |  | C.A5305.570
C.A5305.110 | C.05305.SRV.09.01 | SERVO PANEL | [PHONE] |  |  | 1 | 2012-04-20 00:00:00 | 2012-08-02 00:00:00 | 0 | 2012-07-12 00:00:00 |  | C.A5305.590
C.A5305.110 |  | C.05305.119.51.00 GUARDING ALTERATIONS | [PHONE] |  | pv/db 5/08/12 | 1 | 2012-05-03 00:00:00 | 2012-08-02 00:00:00 | 0 | 2012-07-29 00:00:00 |  | [NAME]
C.A5305.110 | K.00003.022.48.00 | CABLE | [PHONE] |  | bb 03.07.2012 | 160 | 2012-06-27 00:00:00 | 2012-08-02 00:00:00 | 0 | 2012-07-31 00:00:00 |  | C.A5305.610
C.A5305.110 | K.00003.338.70.00 | CONNECTING DISTRIBUTOR | [PHONE] |  | tb27.04.2012 | 1 | 2012-04-27 00:00:00 | 2012-07-30 00:00:00 | 0 | 2012-08-02 00:00:00 |  | C.A5305.620
C.A5305.110 | K.00003.397.90.00 | TRANSFORMER | [PHONE] |  | tb27.04.2012 | 1 | 2012-04-27 00:00:00 | 2012-07-30 00:00:00 | 0 | 2012-08-02 00:00:00 |  | C.A5305.630
C.A5305.110 | K.00003.338.70.00 | CONNECTING DISTRIBUTOR | [PHONE] |  | tb18.06.2012 | 1 | 2012-06-18 00:00:00 | 2012-07-30 00:00:00 | 0 | 2012-08-02 00:00:00 |  | C.A5305.650
C.A5305.110 | K.00003.397.90.00 | TRANSFORMER | [PHONE] |  | tb18.06.2012 | 1 | 2012-06-18 00:00:00 | 2012-07-30 00:00:00 | 0 | 2012-08-02 00:00:00 |  | C.A5305.660
C.A5305.110 | K.00003.418.26.00 | SWITCH DISCONNECTOR | [PHONE] |  | tb27.04.2012 | 2 | 2012-04-27 00:00:00 | 2012-08-02 00:00:00 | 0 | 2012-08-02 00:00:00 |  | C.A5305.670
C.A5305.110 | K.00003.459.91.00 | HANDLE | [PHONE] |  |  | 18 | 2012-07-12 00:00:00 | 2012-07-30 00:00:00 | 0 | 2012-08-03 00:00:00 |  | C.A5305.680
C.A5305.110 | K.00003.338.70.00 | CONNECTING DISTRIBUTOR | [PHONE] |  | bb/jb - 05/14/12 | 1 | 2012-05-11 00:00:00 | 2012-08-02 00:00:00 | 0 | 2012-08-09 00:00:00 |  | C.A5305.690
C.A5305.110 | K.00003.397.90.00 | TRANSFORMER | [PHONE] |  | bb/jb - 05/14/12 | 1 | 2012-05-11 00:00:00 | 2012-08-02 00:00:00 | 0 | 2012-08-09 00:00:00 |  | C.A5305.700
C.A5305.110 | K.00003.418.26.00 | SWITCH DISCONNECTOR | [PHONE] |  | bb/jb - 05/14/12 | 2 | 2012-05-11 00:00:00 | 2012-08-02 00:00:00 | 0 | 2012-08-09 00:00:00 |  | C.A5305.710
C.A5305.110 | K.00003.356.34.00 | CONNECTION CABLE | [PHONE] |  | bb 18.06.2012 | 2 | 2012-06-11 00:00:00 | 2012-08-02 00:00:00 | 0 | 2012-08-10 00:00:00 |  | C.A5305.720
C.A5305.110 | C.05305.118.M1.00 | SYSTEM PROGRAM - SIMULATION | [PHONE] |  | TC 18.06.2012 | 1 | 2012-06-15 00:00:00 | 2012-08-13 00:00:00 | 0 | 2012-08-13 00:00:00 |  | C.A5305.730
C.A5305.110 | K.00003.166.21.00 | CONNECTION CABLE | [PHONE] |  | bb 30.05.2012 | 16 | 2012-05-25 00:00:00 | 2012-07-30 00:00:00 | 0 | 2012-08-24 00:00:00 |  | C.A5305.760
C.A5305.110 | K.00003.166.16.00 | CONNECTION CABLE | [PHONE] |  | bb 30.05.2012 | 17 | 2012-05-25 00:00:00 | 2012-08-02 00:00:00 | 1 | 2012-08-24 00:00:00 |  | C.A5305.780
C.A5305.110 | K.00003.166.17.00 | CONNECTION CABLE | [PHONE] |  | bb 30.05.2012 | 25 | 2012-05-25 00:00:00 | 2012-08-02 00:00:00 | 7 | 2012-08-24 00:00:00 |  | C.A5305.790
C.A5305.110 | K.00003.192.16.00 | CONNECTION CABLE | [PHONE] |  | bb/jb - 06/01/12 | 2 | 2012-05-25 00:00:00 | 2012-08-02 00:00:00 | 0 | 2012-08-24 00:00:00 |  | C.A5305.800
C.A5305.110 | K.00003.198.55.00 | CONNECTION CABLE | [PHONE] |  | bb/jb - 06/01/12 | 2 | 2012-05-25 00:00:00 | 2012-08-02 00:00:00 | 0 | 2012-08-24 00:00:00 |  | C.A5305.810
C.A5305.110 | K.00003.397.46.00 | CONNECTION CABLE | [PHONE] |  | BB 20.06.2012 | 3 | 2012-06-11 00:00:00 | 2012-08-02 00:00:00 | 0 | 2012-08-24 00:00:00 |  | C.A5305.830
C.A5305.110 | K.00003.396.80.00 | CONNECTION CABLE | [PHONE] |  | BB 20.06.2012 | 4 | 2012-06-11 00:00:00 | 2012-08-02 00:00:00 | 0 | 2012-08-24 00:00:00 |  | C.A5305.840
C.A5305.110 | [NAME] | CONNECTION CABLE | [PHONE] |  | bb/jb - 6/26/12 | 1 | 2012-06-15 00:00:00 | 2012-08-02 00:00:00 | 0 | 2012-08-24 00:00:00 |  | C.A5305.850
C.A5305.110 | K.00003.405.45.00 | CONNECTION CABLE | [PHONE] |  | bb/jb - 6/26/12 | 1 | 2012-06-15 00:00:00 | 2012-08-02 00:00:00 | 0 | 2012-08-24 00:00:00 |  | C.A5305.860
C.A5305.110 | K.00003.192.16.00 | CONNECTION CABLE | [PHONE] |  | bb/jb - 6/26/12 | 1 | 2012-06-15 00:00:00 | 2012-08-02 00:00:00 | 0 | 2012-08-24 00:00:00 |  | C.A5305.870
C.A5305.110 | K.00003.374.90.00 | CONNECTION CABLE | [PHONE] |  | bb 09.07.2012 | 1 | 2012-06-28 00:00:00 | 2012-08-02 00:00:00 | 0 | 2012-08-24 00:00:00 |  | C.A5305.890
C.A5305.120 |  | C.A5305.120 SUb-Contract Eng. | [PHONE] |  |  | 1 | 2012-05-22 00:00:00 | 2012-08-02 00:00:00 | 0 | 2012-06-18 00:00:00 |  | C.A5305.900