Query and exclude (is there a NOR option)

@Ryan Moore You shouldn't need to do this in Excel. I usually try to accomplish this type of thing in Query List (Database view function not webview) if possible, but if you can't do it via a subtraction there, you can merge two queries in RE and use a NOR option.

@Ryan Moore
I think you really are overthinking it.

first of all.. you are simply looking for gifts from a certain ONE appeal, simple enough.

Then it is the date range, you have 4 variables used in your date range: A, B, C, D. if you get clear on what exactly it is you want out of the date range, then it's likely a simple query.

You mentioned:

range A to B
range C to D (this is where it is unclear, is C after B or before)
finally you mention A to D subtract C to D.

Assuming you didn't have a typo:

if:
A=2/5
B=2/10
C=2/15
D=2/20
where C is later than B
THEN your date range is just 2/5-2/14, that's ONE date criteria range using:
“Gift Date” between 2/5 and 2/14
OR you can do TWO date criteria using:
“GIft Date” is on or after 2/5
AND “Gift Date” is before 2/15

if:
A=2/5
B=2/10
C=2/8
D=2/20
where C is actually earlier than B
THEN your date range is just 2/5-2/7.

@Ryan Moore
If i'm understanding you correctly, you want list of constituent who gave to certain appeal within a date range but want to remove those that is giving in another range.

Constituent Query:
Summary of Gift Amount (sub-criteria: appeal=XXX gift date: Between 1/1/2013-12/31/2019) greater than $0
AND
Summary of Gift Amount (sub-criteria: appeal=XXX gift date greater than or equal to 1/1/2020) equals to $0
AND
Constituent Code criteria

@Ryan Moore If I'm understanding your end objective correctly, I think what you could do is add the first query that you mentioned to a Query List. Then, if you want to remove those who stopped giving prior to 2020, you could create a second query of Last Gift Date before 12-31-20. In Query List, you can use the Remove function to subtract those in the second query from the starting query.