Excel help needed

[Om1987]

I need help with a Nested IF formula.


If Date1 = Date1 + 7 days and Date2 is Blank, then "Return Window Closed",
If Date1 < Date1 + 7 days and Date2 is Blank, then "Awaiting Return"


if Date2 is not Blank then "Return Received".


If Date1 and Date2 is Blank then show nothing on the cell.

 

[jtakw]

Hi,

You Must re-explain your logic.

Date1 = Date1 +7, this is Not possible, you're saying if 1 = 1 + 8
Date1 < Date1 +7, this will Always be True, you're saying 1 < 1 + 8

 

[jtakw]

Hi,

You Must re-explain your logic.

Date1 = Date1 +7, this is Not possible, you're saying if 1 = 1 + 8
Date1 < Date1 +7, this will Always be True, you're saying 1 < 1 + 8

Meant 7