IF & AND & OR Statement

[brian_2me]

Hi,

Trying to use a IF AND OR statement to check if an action was completed on time. See attached sheet.

There is a due date, actual date completed (which could be blank, due to action not complete), basically i have 3 statements that im trying to combine
Result here in C2 should = NO, as no close date entered in cell B2, therefore, A2<=D1 (D1 =today())
Result here in C3 should = NO, as close date entered in cell B3 >A3
Result here in C4 should = YES, as close date entered in cell B4 <=A4

Happy Friday all

[davsth]

=IF(OR(B2="",B2-A2>=0),"No","yes")

[brian_2me]

Working perfect. Thanking you

[brian_2me]

Sorry, just one issue, where A2 date is greater than todays date and M2 is empty, the result of the above formula is NO but should be YES

[davsth]

M2? do you mean b2?

=IF(OR(AND(B5="",A5<$D$1),AND(B5>0,B5-A5>=0)),"No","yes")

[brian_2me]

Thanks you make it look so easy

Thread closed