How can I query only the last 7 days to be ab...

[Audiovisual_Ser]

How can I query only the last 7 days to be able to automate and present a weekly report?

Please help!.. I’m now using this query where Column B is the date

=QUERY(‘VEHICLE LOG SHEET’!B5:M, “select B, D, E, F, G, H, I, J, K, L, M where C = ‘T-191’”)