Forum Discussion
Counting totals based on the previous 4 weeks
I have looked all over and cannot seem to find what I am looking for so hopefully this awesome community will be able to help. I need to calculate the total # of times an event has happened over ...
You may use this formula:
=COUNTIFS($A$2:INDEX($A:$A,COUNTA($A:$A)),
">="&TODAY()-28,
$A$2:INDEX($A:$A,COUNTA($A:$A)),
"<="&TODAY())
=COUNTIFS($A$2:INDEX($A:$A,COUNTA($A:$A)),
">="&TODAY()-28,
$A$2:INDEX($A:$A,COUNTA($A:$A)),
"<="&TODAY())