gayathiri
New member
- Joined
- Jul 17, 2018
- Messages
- 1
- Reaction score
- 0
- Points
- 0
- Excel Version(s)
- 2013
target date of delivery | actual date of delivery | status |
11-07-18 | 09-07-18 | early delivery |
08-07-18 | 09-07-18 | delay delivery |
10-07-18 | 05-07-18 | early delivery |
11-07-18 | 14-07-18 | delay delivery |
11-07-18 | 10-07-18 | early delivery |
11-07-18 | 11-07-18 | on time delivery |
13-07-18 | on process |
as of now i am using this formula
=if(isblank(i12),"on process",if(h12=i12,"on time delivery",if(h12<i12,"delay delivery","early delivery")))
but now i want change the formula like "target date is greater than actual date + 2 days " it should display "on time delivery"
tia