SUMIFS with date: count within the last 7 days
I'm looking to count the number of punches at various rec centers within the last 7 days. Rec centers have dropdowns with locations. Punches is a numeric value with a daily total. Each center has a daily total.
I have a separate sheet for calculations. I'm looking for a formula related to each center to count the number of punches within the last 7 days.
Any help appreciated!
Help Article Resources
Check out the Formula Handbook template!