Formula to exclude loans with certain criteria

[brandonmcg]

I have a list of loans with data ranging from A to AU and 33,000 rows. Each column has its own header or title.

I need the results of my formula to appear on a new tab so I am guessing put the formula on the new tab?

If Column B equals $0.00 and column C (date field) is null or a date prior to 01/01/2020 then I need all of the remaining loans and their data to be moved to the new spreadsheet.

Column B could be $0.00 but if it has a date in 2020 that is fine I need the results.
B Could also have a dollar amount but should not have a date in column C.

LOAN NUMBER	FIRST PRINCIPAL BALANCE	PAYMENT IN FULL DATE	Move to new spreadsheet?
123456	123,456.00		Yes
46514651	345,678.00		Yes
651651	0.00		No
12345547	5,165.00		Yes
651651	0.00	03/24/2020	Yes
3213651	0.00	11/17/2020	Yes
16416	984,811.00		Yes
86484	1,563.00		Yes
7391852	0.00	02/01/2019	No

 

[brandonmcg]

I am fine if there are other alternatives and open to suggestions how to remove these from the list.