Spreadsheet: 67196d1267788207-vlookup-dates-vlookup-dates-v2
Sheet: Sheet1

 |  |  |  |  |  |  | Mob | Helper Col |  |  |  |  | DeMob | Helper Columns
BADGE# | CBS | Name | Position | MOB | DEMOB |  |  |  |  | Col Return | Row Return |  |  |  |  | Col Return | Row Return
VIS0424 | 088466CNGCPC01 |  | PROJECT MANAGER | 2010-05-01 00:00:00 | 2011-07-31 00:00:00 |  | 2010-05-01 00:00:00 | 1 | 2010-05-31 00:00:00 | 5 | 4 |  | 2011-07-15 00:00:00 | 0.5 | 2011-07-31 00:00:00 | 22 | 4
IMS035 | 088466CNGCPC01 |  | DEPUTY PROJECT MANAGER |  |  |  | #N/A | #N/A |  | #N/A | 5 |  | #N/A | #N/A |  | #N/A | 5
15918 | 088466CNGCPC01 |  | CONSTRUCTION MANAGER | 2010-05-01 00:00:00 | 2011-05-31 00:00:00 |  | 2010-05-01 00:00:00 | 1 | 2010-05-31 00:00:00 | 5 | 6 |  | 2011-05-31 00:00:00 | 1 | 2011-05-31 00:00:00 | 20 | 6
TBA 2A | 088466CNGCPC01 |  | DEPUTY CONSTRUCTION MGR. | 2010-03-01 00:00:00 | 2011-07-31 00:00:00 |  | 2010-03-01 00:00:00 | 1 | 2010-03-31 00:00:00 | 3 | 7 |  | 2011-07-31 00:00:00 | 1 | 2011-07-31 00:00:00 | 22 | 7
TBA 2B | 088466CNGCPC01 |  | DEPUTY CONSTRUCTION MGR. |  |  |  | #N/A | #N/A |  | #N/A |  |  | #N/A | #N/A |  | #N/A
TBA 2C | 088466CNGCPC01 |  | DEPUTY CONSTRUCTION MGR. |  |  |  | #N/A | #N/A |  | #N/A |  |  | #N/A | #N/A |  | #N/A |  | 2011-04-30 00:00:00
TBA 3 | 088466CNGCPC01 |  | H.S.E. MANAGER | 2010-06-15 00:00:00 | 2011-07-31 00:00:00 |  | 2010-06-15 00:00:00 | 0.5 | 2010-06-30 00:00:00 | 6 | 8 |  | 2011-07-31 00:00:00 | 1 | 2011-07-31 00:00:00 | 22 | 8
TBA 30 | 088466CNGCPC01 |  | PROJECT CONTROL MGR. | 2010-04-15 00:00:00 | 2011-06-30 00:00:00 |  | 2010-04-15 00:00:00 | 0.5 | 2010-04-30 00:00:00 | 4 | 9 |  | 2011-06-15 00:00:00 | 0.5 | 2011-06-30 00:00:00 | 21 | 9
TBA 4 | 088466CNGCPC01 |  | INTERFACE COORDINATOR |  |  |  | #N/A | #N/A |  | #N/A | 10 |  | #N/A | #N/A |  | #N/A | 10
TBA 7 | 088466CNGCPC01 | TBA | CONTRACT MANAGER |  |  |  | #N/A | #N/A |  | #N/A | 11 |  | #N/A | #N/A |  | #N/A | 11
TBA 8 | 088466CNGCPC01 | TBA | QUALITY MANAGER | 2010-05-15 00:00:00 | 2011-07-31 00:00:00 |  | 2010-05-15 00:00:00 | 0.5 | 2010-05-31 00:00:00 | 5 | 12 |  | 2011-07-31 00:00:00 | 1 | 2011-07-31 00:00:00 | 22 | 12
TBA 9 | 088466CNGCPC01 | TBA | FIELD ENGINEER | 2010-05-15 00:00:00 | 2011-07-31 00:00:00 |  | 2010-05-15 00:00:00 | 0.5 | 2010-05-31 00:00:00 | 5 | 13 |  | 2011-07-31 00:00:00 | 1 | 2011-07-31 00:00:00 | 22 | 13
TBA 10 | 088466CNGCPC01 | TBA | DOCTOR | 2010-06-15 00:00:00 | 2011-07-31 00:00:00 |  | 2010-06-15 00:00:00 | 0.5 | 2010-06-30 00:00:00 | 6 | 14 |  | 2011-07-31 00:00:00 | 1 | 2011-07-31 00:00:00 | 22 | 14
TBA 11 | 088466CNGCPC01 | TBA | SECURITY COORDINATOR | 2010-01-01 00:00:00 | 2011-07-31 00:00:00 |  | 2010-01-01 00:00:00 | 1 | 2010-01-31 00:00:00 | 1 | 15 |  | 2011-07-31 00:00:00 | 1 | 2011-07-31 00:00:00 | 22 | 15
TBA 12 | 088466CNGCPC01 | TBA | SECURITY COORDINATOR |  |  |  | #N/A | #N/A |  | #N/A |  |  | #N/A | #N/A |  | #N/A
TBA 13 | 088466CNGCPC01 | TBA | LOGISTIC MANAGER | 2010-03-01 00:00:00 | 2011-04-30 00:00:00 |  | 2010-03-01 00:00:00 | 1 | 2010-03-31 00:00:00 | 3 | 16 |  | 2011-04-30 00:00:00 | 1 | 2011-04-30 00:00:00 | 19 | 16
TBA 14 | 088466CNGCPC01 | TBA | PRECOMM/COMMISSIONING MGR. | 2011-01-15 00:00:00 | 2011-07-31 00:00:00 |  | 2011-01-15 00:00:00 | 0.5 | 2011-01-31 00:00:00 | 13 | 17 |  | 2011-07-31 00:00:00 | 1 | 2011-07-31 00:00:00 | 22 | 17
TBA 15 | 088466CNGCPC01 | TBA | SITE PREP SUPERINTENDENT | 2010-01-15 00:00:00 | 2010-04-30 00:00:00 |  | 2010-01-15 00:00:00 | 0.5 | 2010-01-31 00:00:00 | 1 | 18 |  | 2010-04-15 00:00:00 | 0.5 | 2010-04-30 00:00:00 | 7 | 18
TBA 16 | 088466CNGCPC01 | TBA | MECHANICAL SUPERINTENDENT | 2010-07-01 00:00:00 | 2011-03-31 00:00:00 |  | 2010-07-01 00:00:00 | 1 | 2010-07-31 00:00:00 | 7 | 19 |  | 2011-03-31 00:00:00 | 1 | 2011-03-31 00:00:00 | 18 | 19