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.