EXCEL Formula help - Possible Nested IF's

[SexySarah]

Hiya,

I am trying to work something out but I am getting stressed.

I've been at it for hours now.

Maybe some angel can help.

For Column Sale date actual, I am trying to see if Sale_Date contains a Value and is not Blank, If it is blank I want it to return blank, if it is not blank, then I want to see if Cancelled Status equals either Sale or Install in progress, and then return the Sale Date, otherwise return the Sale Date if that condition is not met.

My attempt below does not work as the first row for example should return the Sale_Date:


=IF($A2="",""(IF(OR($B2="Sale",$B2="Installation in Progress"),$A2,"")),$A2)

Then I am trying to find the weeknumber in column D.