I have a google spreadsheet with dates that are in the future as well as in the past and am trying to countifs all the dates that are within the last 7 days and NOT the dates in the future. That is where ">"TODAY()-7 comes in.

I have been trying to use =COUNTIFS(VALUES!A:A,">"&TODAY()-7,VALUES!B:B,"SCHEDULED") but this counts the dates for the future as well. Would I add something that counts the dats inbetween two other values?

Here is a spreadsheet for this problem: https://docs.google.com/spreadsheets/d/1GjbssbJ-YxmhNMir4cv_0BgzT0ZmbpX2poMm9gKTgaU/edit?usp=sharing

CodePudding user response：

Try this...

=COUNTA(FILTER(A:A,A:A<=today(),A:A>=Today()-7,B:B="SCHEDULED"))