Multiple Criteria which Results in Multiple Rows (Data)

Hi All

Hope you are doing Good !!!

I want to Apply a Formula in Excel which can Return Multiple Rows based on the Two Conditions i.e. on Two Columns or Fields i.e., Status & Resolved

Status Field could have any value e.g. Waiting for customer, Closed, Escalated to Third Party, In Progress, Escalate to Oracle

Resolved Field should be within Month i.e. Aug 1, 2022 to Aug 31, 2022

Those Records who have No Value in Resolved field should also be displayed i.e. they are Not Closed before or in Aug 2022

I have attached the excel sheet with initial data and required result in other sheet

Thanks in Advance

Regards
Shahzad

Thanks Ali GW

Much Appreciated for your Efforts !!!

It has worked.
But upon Checking it is Missing 2 Records KEMS4-63 & KEMS4-64.
I have mentioned both Records in below.

Key Summary Created Status Severity Resolved
KEMS4-63 Session with KE IT on SSL issue at SAP-PI 31-Aug-22 Waiting for customer 4 = Low
KEMS4-64 Estimation Job Issue 31-Aug-22 Waiting for customer 2 = High

I have tried to modified Formula to include <= in End Date as shown below

=FILTER('31082022'!A2:F64,('31082022'!D2:D64<>"")*(('31082022'!F2:F64="")+(('31082022'!F2:F64>=DATE(2022,8,1))*('31082022'!F2:F64<=DATE(2022,8,31)))))

But still No Luck
Any Idea about this

Regards
Shahzad