Should I use an If Statment

[Ivyk_P1975]

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

[#2]

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