Forum Discussion
Should I use an If Statment
Hello, I am not very good at excel. I am tasked with trying to figure out if DTs were released in sufficient lead time, they should be released 2 days before the shipping date. I have the ship date and when the DT was created. I know it may seem simple but I need help
| Total Del | Order qty | DT Ship | US Canc. | US Hdr | DT Create | US Ship M | Ship Week |
| 150 | 150 | 9/8/2023 | 6/27/2023 | 8/30/2023 | 6/27/2023 | Prior to Week 35 | |
| 150 | 150 | 9/8/2023 | 6/27/2023 | 8/30/2023 | 6/27/2023 | Prior to Week 35 | |
| 468 | 468 | 9/8/2023 | 7/4/2023 | 8/30/2023 | 7/4/2023 | Prior to Week 35 | |
| 17 | 17 | 8/18/2023 | 8/27/2023 | 8/15/2023 | 8/1/2023 | Prior to Week 35 | |
| 6 | 6 | 8/16/2023 | 8/2/2023 | 8/16/2023 | 8/16/2023 | Prior to Week 35 | |
| 29 | 29 | 9/7/2023 | 9/14/2023 | 9/7/2023 | 8/29/2023 | 8/21/2023 | Prior to Week 35 |
| 41 | 41 | 9/7/2023 | 9/14/2023 | 9/7/2023 | 8/29/2023 | 8/21/2023 | Prior to Week 35 |
| 80 | 80 | 9/7/2023 | 9/14/2023 | 9/7/2023 | 8/29/2023 | 8/21/2023 | Prior to Week 35 |
| 20 | 20 | 9/18/2023 | 9/22/2023 | 8/3/2023 | 8/30/2023 | 9/18/2023 | Week 38 |
| 12 | 12 | 9/18/2023 | 9/22/2023 | 8/3/2023 | 8/30/2023 | 9/18/2023 | Week 38 |
| 10 | 10 | 9/18/2023 | 9/22/2023 | 8/3/2023 | 8/30/2023 | 9/18/2023 | Week 38 |
| 30 | 30 | 9/18/2023 | 9/22/2023 | 8/3/2023 | 8/30/2023 | 9/18/2023 | Week 38 |
| 22 | 22 | 9/18/2023 | 9/22/2023 | 8/3/2023 | 8/30/2023 | 9/18/2023 | Week 38 |
Hi Ivyk_P1975,
you can use a formula to check if the DTs were released with sufficient lead time:
1. In an empty column, where you want to display the result (for example: in column L), enter the following formula in the first cell (for example L2):
=IF(D2 - H2 >= 2, "Yes", "No")- `D2` represents the "DT Ship" date for the current row.
- `H2` represents the "US Ship" date for the current row.
- This formula calculates the difference in days between the "DT Ship" date and the "US Ship" date.2. Press "Enter" to apply the formula. The cell will display "Yes" if the DTs were released with at least 2 days of lead time, and "No" if not.
3. Copy this formula down to apply it to all rows in your dataset. Excel will calculate the lead time for each row.
The result will indicate "Yes" for rows where the DTs were released with sufficient lead time and "No" for rows where they were not.
Please click Mark as Best Response & Like if my post helped you to solve your issue.
This will help others to find the correct solution easily. It also closes the item.If the post was useful in other ways, please consider giving it Like.
Kindest regards,
Leon Pavesic
