report by DV & date criteria

[rumkus]

sheet1 - data -

date, field1, field2, field3, field4, field5

sheet 2 - filtered report -

C1. begin date - if blank then till C2 if C2 is blank then all
C2. end date - if blank then starts from C1 or all
C3. field1 DV - if blank then all
C4. field2 DV - if blank then all
C5. field3 DV - if blank then all

Report starting row . B8 - sort by date.

Working on A8 formula for hours failed each time.
Should I really resort to VBA ?
Any help even a right direction ? Thank you very much.

 

[rumkus]

With helper columns I managed to create the report.
Starting from G8 as
Date, Field1, Field2.etc

Don't know how I can sort it by formula.
Any idea ? Thank you.

 

[rumkus]

Done it with a helper sheet .
Thank you Max for AutoSort_DateOrder_.... wks.

rgds