Should I use an If Statment

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.