Need Help With the best way to go about applying a COUNTIFS formula

Good morning! I've attached my work for reference. I've narrowed down that I need to use a COUNTIFS formula to be able to filter the information that I need. I have two columns containing dates. One is the date the property was obtained. The other is the date that it was sold. What I need is to be able to input a given date, and have the owner of each property on that given date either highlight or filter. I believe a COUNTIFS formula is going to be the best way to do this, as adding auto filters just filters out information from the first column. I'm not very familiar with COUNTIFS formula, so any help to put one together that will do what I need it to do will be greatly appreciated. Thanks!

So if it’s after the “Sold” date, then it is the person in column D and if it’s before the “Sold” date, it’s the person in column C? Does this apply if it’s before the “Obtained Date” or should it be ignored in that case?

Should someone (C or D) be highlighted on every line?

Okay, with C6 To C10000 selected, this formula in conditional formatting

Formula:

Please Login or Register  to view this content.

With D6:D10000 selected, this formula in conditional formatting

Formula:

Please Login or Register  to view this content.

See attached

Okay, In P6 with the formula copied down

Formula:

Please Login or Register  to view this content.

This will give you a 1 if the owner is in column C and a 2 if in column D and “”(null set) if neither.
Then a simple Conditional formatting
In C6:C10000

Formula:

Please Login or Register  to view this content.

In D6:D10000

Formula:

Please Login or Register  to view this content.

Is this what you are looking for?

Glad to help