Formula to capture last 7 days of data

Summary

Formula to capture last 7 days of data

Content

Hello,

 

We are looking to capture requisition in specific statuses (Approved, To Be Approved, Draft, Sourcing and Filled) for the last seven calendar days.  Look for assistance in creating a formula to capture that timeframe so I can set up a weekly agent to run the report.