Nested IF`s and Blank cells

Hi, I need help on a formula ( in F column ) that can tell me if the materials are on delay or not.

Written down i see it like this :
if E3>D3+6="delay",else"ok", if E3>C3+6="delay",else"ok", if E3>B3+6="delay",else "ok"

This is clear but now i`m having the other situations where i have no info ( blanks ) in C3 or D3 , that i have no ideea how to deal it.
ex. if D3 is blank do the if E3>C3+6="delay",else"ok" and if C3 is blank do the if E3>B3+6="delay",else "ok" and if E3 is blank do the
if today()>D3+6="delay",else"ok" or if D3 is blank do the if today()>C3+6="delay",else"ok" or if C3 is blank too , do the if today()>C3+6="delay",else"ok"


okdelay.jpg


i hope i explained my problem enough soo i can get some help.
i did before the nested if-s but not with isblank and with soo many conditions.
i`m not sure even if it can be done or not .

thanks in advance.

i need to explain more,

first i receive the dates in C , dates in D are the latest infos soo those count. in case i don`t have dates in D i`ll use dates in C, if C is without dates too , i`ll use the dates in B .

Ex. E3 = 21.02.2015 , the D3+6 is grather than E3 soo ok. C3 is not counting anymore because i have a date in D3.
case 2 : E4 = 28.02.2015 , D4+6 is smaller than D4 soo delayed. C3 is blank , not counting.
case 3 : E5 = 15.02.2015, C5+6 is grather than E5 soo ok .D5 is blank that`s why we are using C5 .

6 are the days that the goods are on the way to us via road transportation.




it seems that i did a major mistake in my first post/request regarding who is grather and who is smaller, i`m very sorry about that .


Here are the corrected ones :


Written down i see it like this :
if E3<D3+6="delay",else"ok", if E3<C3+6="delay",else"ok", if E3<B3+6="delay",else "ok"

This is clear but now i`m having the other situations where i have no info ( blanks ) in C3 or D3 , that i have no ideea how to deal it.
ex. if D3 is blank do the if E3<C3+6="delay",else"ok" and if C3 is blank do the if E3<B3+6="delay",else "ok" and if E3 is blank do the
if today()>D3+6="delay",else"ok" or if D3 is blank do the if today()>C3+6="delay",else"ok" or if C3 is blank too , do the if today()>C3+6="delay",else"ok"

please find attached file with the sample, in the last column ( where the formula should operate i`ve put the right answers )
OK_DELAY_.xlsx

thanks again.

Works just fine , except the case when i have only a date in B3, in the other fields i have none.

ex. B3=15.02.2013 it will show me delay - in fact that`s not true , because today is not past 15.02.