I am trying to make an impact report that will quickly allow a customer to quickly understand the impact of set a weeks work and any delays in their schedule. What i would like to do is make a table with Column A being the project ID, Column B to BA represent a work week, and column BB be the scheduled completion date. Each week I want to be able to add or subtract day from the schedule by using inputting a number, 0= no impact Positive numbers = a delay and days added to the schedule, and Negative numbers = high productivity and subtract days form the schedule. I want to use conditional formatting to highlight green for negative numbers or 0, red for positive. This is easy enough however i would also like to use a formula to auto correct the return date based on values entered each week. I am unsure how to accomplish this any ideas? I have included a simplified example below in case i was unclear.
<tbody>
</tbody>
Project ID | WW1 | WW2 | Return Date |
Work order 1 | 10/10/19 | ||
Work order 2 | 11/12/19 | ||
Work order 3 | 1/25/20 | ||
Work order 4 | 2/15/20 |
<tbody>
</tbody>