I am tracking dates and want to calculate the estimated delivery date in a single cell as I populate dates in each milestone.
So I have a 60 day(E), 15 day(F), 5 day(G) notification column. I record the date I receive these notices in their respective column. I want to create an estimated delivery date column (H) based on the most recent date.
Example
<tbody>
</tbody>
So I have a 60 day(E), 15 day(F), 5 day(G) notification column. I record the date I receive these notices in their respective column. I want to create an estimated delivery date column (H) based on the most recent date.
Example
60 Calendar Day Notice | 15 Business Day Notice | 5 Business Day Notice | Estimated Delivery Date |
2019-06-03 | 2019-08-02 | ||
2019-06-01 | 2019-07-16 | 2019-08-06 | |
2019-05-21 | 2019-07-05 | 2019-07-26 | 2019-08-02 |
<tbody>
</tbody>