conditional date comparison columns a or b

[frustrated_macro]

So i have to compare a list of dates to see if the delivery of materials is late
Lets say:
in column A i have the Regions estimated delivery
in column B i have the expected delivery
in column C i have a formula that tells me if X date is before today, making it late

The report recently changed. Right now, in C i have the following formula =IF(A7<=TODAY(),"YES.","NO.")

So now i need to be able to tell excel

• If there is a date in A, but nothing in B =IF(A7<=TODAY(),"YES.","NO.")
• If there is a date in A and a date in B =IF(B7<=TODAY(),"YES.","NO.")
• If there no date in A and yes a date in B =IF(B7<=TODAY(),"YES.","NO.")

Im not sure if thats a macro thing, or just a complex formula
Also, this formula is currently a step in a macro to fill in and format a certain way so it would be great if i could just alter the formula to match the new conditions

 

[kweaver]

This this long formula work?

Excel 2010
	A	B	C
6	Est. Delivery	Expected Delivery
7	9/1/2019	9/25/2019	NO
8	9/2/2019		YES
9		9/2/2019	YES
10	9/1/2019	9/2/2019	YES
11	9/25/2019		NO
12		9/20/2019	NO
Sheet23

Cell Formulas
Range	Formula
C7	=IF(AND(NOT(ISBLANK(A7)),NOT(ISBLANK(B7)),B7<=TODAY()),"YES",IF(AND(NOT(ISBLANK(A7)),ISBLANK(B7),A7<=TODAY()),"YES",IF(AND(ISBLANK(A7),NOT(ISBLANK(B7)),B7<=TODAY()),"YES","NO")))