Google Sheets create table based on date filter on original table-CodePudding

Link to sample sheet:

I'm assuming that I will need to use Query() to solve this but I can't figure out how to get started. Google searches are not being very helpful and I would appreciate at least a suggestion on how to get this done.

CodePudding user response：

try:

=FILTER({A3:C, IFERROR(A3:A/0, TEXT(TODAY(), "e-d-m")), F3:H}, 
 TODAY()>=D3:D, TODAY()<=E3:E)

update 1:

={FILTER({A3:C, IFERROR(A3:A/0, TEXT(TODAY(), "e-d-m")), F3:H}, TODAY()>=D3:D, TODAY()<=E3:E); 
  FILTER({A3:C, IFERROR(A3:A/0, TEXT(TODAY(), "e-d-m")), F3:H}, ""=D3:D, ""=E3:E, ""<>A3:A)}

update 2:

=SORTN({
 FILTER({A3:C, IFERROR(A3:A/0, TEXT(TODAY(), "e-d-m")), F3:H}, TODAY()>=D3:D, TODAY()<=E3:E); 
 FILTER({A3:C, IFERROR(A3:A/0, TEXT(TODAY(), "e-d-m")), F3:H}, ""=D3:D, ""=E3:E, ""<>A3:A)}, 9^9, 2, 2, 1)