COUNTIFS , based on previous days - not including current day

SkiPatrolScott

my current formula is

=countifs(field:field, (@cell > TODAY() -7),….. or (@cell> TODAY(-7)…this comes back with a total that included today. Is there a way to count the seven days prior but not count the current day in the formula?

Carson Penticuff

If I understand your question correctly, this should work:

=COUNTIFS(field:field, @cell < TODAY(), field:field, @cell >= TODAY(-7))

SkiPatrolScott

@Carson Penticuff

=COUNTIFS(Date:Date, @cell < TODAY (), Date:Date, @cell >= TODAY (-7)), Activity:Activity,@cell= "Violation")

The field name is Date

comes back #Unparseable

Carson Penticuff

There is an extra closing paren, try this:

=COUNTIFS(Date:Date, @cell < TODAY (), Date:Date, @cell >= TODAY (-7), Activity:Activity, @cell = "Violation")