How to search data between date range

Dear all,

I have data in which Date wise,Customer wise,Product wise sale is mentioned,As I have five years data I want excel should show the data between the date range I selected,Here If I select only date so excel should show all the sale between that range.

And if I select Date & customer so excel should show sale for that particular customer,And If I select Date,Customer name,and Item code, So it should show that particular item sale for the particular customer between that range.

Kindly help me in this regards,

Thanks

Dev.