Spreadsheet: 846819d1697978195-trying-to-create-a-forumla-that-will-sum-a-list-of-values-with-various-date-range-test-spreadsheet
Sheet: Sheet2

 |  |  | Months per cell |  | 0.5
 |  |  | Month Start |  | Jan
 |  |  | Timeline start
 |  |  | Todays Date
 |  |  |  |  | 1900-01-00 |  |  |  | [NAME] - Early Sep |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Adjust VDC duration to start on future date or current date |  |  |  |  | Adjust VDC duration to start on future date or current date |  |  |  |  |  |  |  |  |  |  |  |  | FLIP LOCATION OF MOBILIZATION & OPS STAGE
 |  |  | Disply Week |  | 1 |  |  |  | Boarded up end of Sep |  |  | Logistics | Quantity Take-off | Rendering / Animation | Coordination (Precon) | 4D / 5D | Total VDC Precon Hours | Coordination (Ops) | Production Tracking | AR / VR | Laser Scanning | Total Ops VDC Precon Hours |  | Total VDC Hours |  | Precon Work Start | Precon Work Finish | VDC Precon Duration (Workdays) | VDC Completion |  | Precon Work Start | Precon Work Finish | VDC Precon Duration (Workdays) | VDC Completion |  | Ops Work Start | Ops Work Finish | VDC Operations Duration (Days) | VDC Completion |  | RFP / Kickoff | Award Date | Precon Duration (Days) | Mobilization | Substantial Completion | Ops Duration (Days) | Final Completion | Project Duration (Days) |  | Project Duration | Week 1
 |  |  |  |  |  |  |  |  |  |  |  | Precon |  |  |  |  |  | Operations
 |  |  |  |  |  | # | Status | Project | Building Type | Contact | Value | Task |  |  |  |  |  |  |  |  |  |  |  |  |  | VDC Precon Duration |  |  |  |  | VDC Quantity Take-off |  |  |  |  | VDC Ops Duration |  |  |  |  |  | Total Project Duration
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Ops Duration
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Precon Duration
 |  |  |  |  |  |  |  |  | False |  |  | Include |  |  |  |  |  | Include
 |  |  |  |  |  |  |  |  |  |  |  | True | True | True | True | True |  | True | True | True | True
 |  |  |  |  | yes | 1 | Active | [NAME] | Fitout | [NAME] | $m | 20 | 40 |  |  |  |  |  | 80 |  |  |  |  |  |  | 2023-10-16 00:00:00 | 2023-10-27 00:00:00 |  |  |  | 2023-10-17 00:00:00 | 2023-10-30 00:00:00 |  |  |  | 2023-10-18 00:00:00 | 2023-10-25 00:00:00 |  |  |  | 2023-08-08 00:00:00 | 2023-09-01 00:00:00 |  | 2023-09-19 00:00:00 | 2024-01-18 00:00:00 |  | 2024-02-09 00:00:00 |  |  | Stage
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Hours |  |  |  |  | Hours |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Hours
 |  |  |  |  |  | 2 | Wrap-Up | 777 Bay | Life Science | [NAME] | $19.966m |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2022-04-17 00:00:00 | 2022-09-15 00:00:00 |  |  |  | 2022-04-17 00:00:00 | 2022-09-15 00:00:00 |  |  |  | 2022-10-01 00:00:00 | 2023-07-19 00:00:00 |  |  |  | 2022-04-10 00:00:00 | 2022-05-17 00:00:00 |  | 2022-07-27 00:00:00 | 2023-08-25 00:00:00 |  | 2023-10-25 00:00:00 |  |  | Stage
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Hours
 |  |  |  |  |  | 3 | Awaiting | [NAME] | Life Science | Maya A | $3.186m |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2023-08-31 00:00:00 | 2023-09-08 00:00:00 |  |  |  | 2023-08-31 00:00:00 | 2023-09-20 00:00:00 |  |  |  |  |  |  |  |  | 2023-01-19 00:00:00 | 2023-03-15 00:00:00 |  | 2023-05-29 00:00:00 | 2023-12-22 00:00:00 |  | 2024-01-06 00:00:00 |  |  | Stage
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Hours
 |  |  |  |  |  | 4 | Awaiting | CPAO | Office | [NAME] | $24.160m |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2023-07-01 00:00:00 | 2024-01-25 00:00:00 |  |  |  | 2023-07-01 00:00:00 | 2024-01-25 00:00:00 |  |  |  |  |  |  |  |  | 2022-10-12 00:00:00 | 2023-03-24 00:00:00 |  | 2023-03-30 00:00:00 | 2024-03-07 00:00:00 |  | 2024-09-13 00:00:00 |  |  | Stage
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Hours