I have 2 spreadsheet, the first one consists of all of the data of withdrawal and deposit of items. The second spreadsheet is where the summary of the data shown.
Here is the master data link: https://docs.google.com/spreadsheets/d/1DjSXpLWqFagAI2l2vth4C-XDhV77sSHfYtCEsoG5H_M/edit?usp=sharing
And here is the summary data link: https://docs.google.com/spreadsheets/d/1y8pnYnTpRktyr2BxKDCLPVIqm0pBHkO7AiVfkyhpEC8/edit?usp=sharing
I want to show the data from the master data to the summary data, below the "list", like the data of when, who, and which item is deposited or withdrew, but only the latest week. My knowledge of the query function is not that advanced and i really don't know how to so can you please enlighten me the formula to do so? Thank you