How to create a formula for work completed last week based on a status

Lucinda Bugbee

I have a status column in my sheet and want to understand what work was processed last week for each status. I have a Modified Date column in my sheet and assume I can use this, but don't know how to capture the information.

Paul Newcome

Are you able to provide some screenshots for context? Are you trying to capture what the status was last week and then count them up by status?