I would like to create a calculated field that outputs "Yes" or "No" if an item in my SharePoint list has been
- created in the last 7 days,
- closed in the last 7 days (field in status column), or 3) displays "Open" or "In-Progress" under the status column.