Manufacturer | Start | Stop | Total Days: |
ITRAQ | 1/15/2019 | 1/30/2019 | 15 |
2nd Phase | Start | Stop | Total Days |
CAT MEMO | 1/31/2019 | 2/1/2019 | 1 |
HW/SW LIST | "" | "" | 1 |
Arch | "" | "" | 1 |
PPSM | "" | "" | 1 |
MEMO | "" | "" | 1 |
Criteria | "" | "" | 1 |
CERP# | 2nd Phase Total Days: | 6 | |
Total Days in Total | 21 |
<tbody>
</tbody>
This is the graph i'm stuck with and I'm trying to figure out how I can fix the total days for 2nd Phase Totals Days when the Start and Stop are all the same.
The problem is this adds up to 6 days when its really 1 day. However, if they are all different stop dates? What would the formula be to just grab the highest number out of those cells? Please help me!!!!