Andrew Watson
New Member
- Joined
- Feb 3, 2016
- Messages
- 13
- Office Version
- 365
- Platform
- Windows
I have a report which I download from a database and I determine if a supplier is late with their delivery or not. If we update the vendors 'promise date' the original 'promise date' is transferred to the 'promise original' column. Currently when determining if a vendor is late I use an IF formula to determine if they are 'LATE' or 'ON TIME' using the differences in the 'Close Date' and 'Promise Date' Columns. I would now like to initially look at the 'Promise Original' and calculate off this date versus 'Close Date' in the first instance if they are late or not. If the cell in 'Promise Original' is blank then I would like to calculate from the 'Close Date' and 'Promise Date' Columns. I've tried using a few variations of an IF formula and also adding in an OR as well but I keep getting errors.
Can anyone help with his calculation?
Can anyone help with his calculation?
Book1 | ||||||
---|---|---|---|---|---|---|
B | C | D | E | |||
1 | CLOSE DATE | PROMISE DATE | PROMISE ORIGINAL | ON TIME | ||
2 | 19/07/2021 | 9/07/2021 | 6/07/2021 | LATE | ||
3 | 19/07/2021 | 9/07/2021 | LATE | |||
4 | 9/07/2021 | 9/07/2021 | ON TIME | |||
5 | 8/07/2021 | 9/07/2021 | ON TIME | |||
Sheet1 |
Cell Formulas | ||
---|---|---|
Range | Formula | |
E2:E5 | E2 | =IF(B2<=C2,"ON TIME",IF(B2>C2,"LATE")) |