Previous Week(s) formula

I have a running list of dates in one column and hours spent in another. I'm trying to capture the sum of hours spent over the past week, the week prior and so forth.

I'm using the following formula to sum the hours spent not over the previous 7 days, but 7 - 14 days ago and it appears to be working.

SUMIFS(Total:Total, Date:Date, @cell >= (TODAY(+7)) - 14)

I would expect then that changing the "Today" to ...(TODAY(+14)) - 21 would provide a sum of the hours spent during the days 14 - 21 ago from today. This is returning the same number as (TODAY(+7)) - 14).


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!