I have 1 column I want to indicate either "On track" or "At Risk"..
A1 is a ship date
So B2 is the status from above..
H is Release Date
I is Kit Date
J is Start Date
K is Finish Date
So the logic is this :
If Finish Date + 2days <Ship Date = "On Track"
if Start Date + 3 days <Ship Date = "On Track"
If Kit Date + 4 days <Ship Date = "On Track:
if Release Date + 5 days <Ship Date ' On Track"
These 4 stages will always have data ( or " " values ) because of Vlookups.. so no 'blank cells".
So basically...
if the finish date is blank, the start date is blank, the kit date is blank, but the release date +5 days is < ship date = we are still On Track..
Help.
A1 is a ship date
So B2 is the status from above..
H is Release Date
I is Kit Date
J is Start Date
K is Finish Date
So the logic is this :
If Finish Date + 2days <Ship Date = "On Track"
if Start Date + 3 days <Ship Date = "On Track"
If Kit Date + 4 days <Ship Date = "On Track:
if Release Date + 5 days <Ship Date ' On Track"
These 4 stages will always have data ( or " " values ) because of Vlookups.. so no 'blank cells".
So basically...
if the finish date is blank, the start date is blank, the kit date is blank, but the release date +5 days is < ship date = we are still On Track..
Help.