Need revised formula as referenced cells contain formulas so are not seen as blank, so am not getting desired results

I received a solution from EE that addressed my question, but I subsequently realized (my bad) that the following formula does not work when the cells that the formula is referencing contain underlying formulas, which I hadn't mentioned in my original question. I assume that Excel is not seeing these cells as truly blank?

=IF(OR(AND('Spreadsheet#1'!B2<>"",'Spreadsheet#1'!C2=""),AND('Spreadsheet#1'!D2<>"",'Spreadsheet#1'!E2="")),"Yes","")

So as a result I am posting this as a new question with an updated sample spreadsheet that, this time around, contains the underlying formulas in Spreadsheet #1.

Spreadsheet#1:
Has 5 columns with a heading row:
Column A is a list of chapters in a book
Columns B through E contains an index-match formula pulling date entries from a tab called SourceSpreadsheet.

Spreadsheet#2:
Column A is the list of chapters (linked to Column A in Spreadsheet#1)
Column B — Need a formula that calculates if there is an active query on a chapter by assessing the entries in Columns B through E in Spreadsheet #1 as follows (I have manually entered the desired results in red in Spreadsheet #2):
Spreadsheet#1, if Col B = date entry and Col C = no date entry, then Spreadsheet#2 Col B = Yes
Spreadsheet#1, if Col B = date entry and Col C = date entry, then Spreadsheet#2 Col B = Blank
Spreadsheet#1, if Col D = date entry and Col E = no date entry, then Spreadsheet#2 Col B = Yes
Spreadsheet #1, if Col D = date entry and Col E = date entry, then Spreadsheet#2 Col B = Blank
All remaining combinations = blank cell in Spreadsheet#2, Col B

All date entries use the custom format dd-mmm-yy.

I have attached a sample spreadsheet to help illustrate the updated question.

Thanks,
Andrea
EE_Pulling_QRY_Status_Formulas.xlsx