Different Date Durations Driving Yes/No

may i just clarify the rules

If Column C is 56 days or under I need Column E to say No
If column D is over 56 days, I need Column E to say No

is this an AND
column C is under 56days AND column D is over 56 days - then NO
is that the RULE 1

Are the other rules ALSO AND - all must apply ?


If Column C is blank, I need Column E to say No.
If Column C is 56 days or under I need Column E to say No
If Column D is under 56 days or under I need Column E to say No.
If column D is over 56 days, I need Column E to say No

i have grouped the NO's
SO it would not appear to matter what D is

=IF( OR( C2 ="", C2 < 56 ) , "No",

ok,
what about the questions in my post

Rule One:
If Column C is 56 days or under I need Column E to say No
If column D is over 56 days, I need Column E to say No

Rule Two:
If Column C is over 56 days, I need Column E to say Yes
If Column D is over 56 days, I need Column E to say Yes

Rule Three:
If Column C is blank, I need Column E to say No.
If Column D is under 56 days or under I need Column E to say No.
BUT, if Column D is over 56 days, I need Column E to say Yes
that if B is blank and D goes above 56 days, I need E to show a yes.

I still dont know if these are AND all must apply for each rule

Rule One:
If Column C is 56 days or under I need Column E to say No
AND
If column D is over 56 days, I need Column E to say No

Rule Two:
If Column C is over 56 days, I need Column E to say Yes
AND
If Column D is over 56 days, I need Column E to say Yes

Rule Three:
If Column C is blank, I need Column E to say No.
AND
If Column D is under 56 days or under I need Column E to say No.
OR
BUT, if Column D is over 56 days, I need Column E to say Yes

AND
that if B is blank and D goes above 56 days, I need E to show a yes.

i think we need to put the full conditions/rules for YES all together
AND the same for a NO

yes, I need all the rules to apply if possible.

I understand , BUT what are the rules exactly

really sorry , i am trying to help out here
I have put the rules in for a YES and a NO


I'm not sure I follow all the rules as it could be
If Column C is 56 days or under I need Column E to say No

So not looking at column D
OR
is it
If Column C is 56 days or under AND at the same time column D is over 56 days and only if BOTH apply then its NO in column E

in which case that is
=AND( C2 < = 56 , D2 > 56 )
then in an IF
=IF( AND( C2 < = 56 , D2 > 56 ) , "NO"

BUT we also have
If Column C is blank, I need Column E to say No.
AND
If Column D is under 56 days or under I need Column E to say No.

SO then an OR

=IF( OR( AND( C2 < = 56 , D2 > 56 ) , AND( C2="", D2 < 56 ) ), "NO"

Then for the YES
Rule Two:
OR( AND ( C2 > 56 days, D2 > 56 ) , AND( C2="", D2 > 56 ) ) , "YES"


So we have
=IF( OR(AND(C2<=56,D2 > 56),AND( C2="", D2<56 )), "NO", IF(OR(AND(C2 >56, D2>56 ), AND(C2="", D2>56 )), "YES","No Rule"))

BUT , i'm not 100 sure i follow the rules as mentioned in previous posts

also we dont have an = 56 days in all the conditions

so here it is in column G

can you put the results expected in a column, as you have NO No's and just blank cells