Assuming your dates in column A and points to count in C:
365 days
Formula:
=SUMPRODUCT(($A$2:$A$9>=DATE(YEAR(TODAY()),MONTH(TODAY()),DAY(TODAY())-365))*($C$2:$C$9))
180 days
Formula:
=SUMPRODUCT(($A$2:$A$9>=DATE(YEAR(TODAY()),MONTH(TODAY()),DAY(TODAY())-180))*($C$2:$C$9))
90 days
Formula:
=SUMPRODUCT(($A$2:$A$9>=DATE(YEAR(TODAY()),MONTH(TODAY()),DAY(TODAY())-90))*($C$2:$C$9))
30 days
Formula:
=SUMPRODUCT(($A$2:$A$9>=DATE(YEAR(TODAY()),MONTH(TODAY()),DAY(TODAY())-30))*($C$2:$C$9))
Did you want to have these subtotaled for each row instead? (as in, have each incident show total points for these time ranges)
Bookmarks