If condition

gayathiri

New member
Joined
Jul 17, 2018
Messages
1
Reaction score
0
Points
0
Excel Version(s)
2013
target date of deliveryactual date of deliverystatus
11-07-1809-07-18early delivery
08-07-1809-07-18delay delivery
10-07-1805-07-18early delivery
11-07-1814-07-18delay delivery
11-07-1810-07-18early delivery
11-07-1811-07-18on time delivery
13-07-18on 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
 

AliGW

Administrator
Joined
Nov 8, 2015
Messages
1,785
Reaction score
1
Points
38
Location
Ipswich, Suffolk, England
Excel Version(s)
MS 365 (Beta Insider Channel)
What does that mean in practice? Is the table of data what you want or what you have now and want to change? Does "on time" mean two days before target or two days after target? :confused:

You can simplify this using DATEDIF, but I need you to clarify what you want first.
 
Top