I have an excel spreadsheet used for tracking projects and need to add some functionality for different types of projects and timeline constraints. Below is an example of the 2 conditions I need to meet. Received- When project is received on site.
Construction completion- this is one type of project that requires 3-4 weeks to complete. this date will usually be entered manually, but may be set to start automatically at 4 weeks after Received date. If if does not require construction it is set to n.a.
Midi Expected- This is where I need a statement that reads if there is a date in "Construction Completion" add 7, if there is not then use the date in received and add 7.
QC Completion- This is simply Midi Expected + 7
| Received | Construction Completion | Midi Expected | QC Completion |
|---|---|---|---|
| 5/20/2021 | n.a. | 5/7/2021 | 5/14/2021 |
| 5/20/2021 | 6/10/2021 | 6/17/2021 | 6/24/2021 |
Aucun commentaire:
Enregistrer un commentaire