OK so here is the scenario:

I have a whole bunch of expiration dates in a range. I am trying to set up a formula to count the number of those expiration dates that fall between a week from today and 3 weeks from today. Here is the formula i came up with, but its returning the wrong answer.

=COUNTIF('01 Chicago'!G2:H116,">(TODAY()+7)") - COUNTIF(same range,">(TODAY()+21)")

i am counting the number of dates that will expire anytime after a week from today. then subtracting the number of dates that expire anytime after three weeks from today leaving me with the number of dates that are expiring between one week and three weeks from today.

If there is a way to set up multiple criteria in a countif statement i guess that would work too but i don't know how.