Rolling Current Month Weekly Report
I'm hoping someone has a potential solution for what I'm trying to accomplish:
I have 500 sheets that I am rolling up into 1 Sheet Summary Report. Each of the 500 sheets has summary data that is included in the Summary Report. The Summary Report needs to be sent to the business owners on a weekly basis. In the report I need to include the data from the previous week for the current month. If we are in the middle of the month, I would need to provide all of the previous weeks' information.
For example -
- Monday, April 3rd would include April 1st to April 2nd
- Monday, April 10th would include April 1st to April 9th
- Monday, April 17th would include April 1st to April 16th, and so on until we got to May then it would start fresh because a cumulative report for the previous month is sent
I was hoping that I could use created date (added a filter on Created to be between 4/1/23 to 4/6/23 but the information is not displaying). I'm suspecting that the Created Date is when the Summary Sheet was created and not when the new row was added. I have confirmed I have rows in the sheet with a Created Date in the range.
Any guidance would be greatly appreciated.