Need to expand a report that pulls selected date's activities, to range of dates

One sheet is a daily log of an employees activities for that current month. Another sheet is my summary where I can select a date like 1/25/16 and it will populate only that day's activities based on the daily log the employees fill out. Perfect for seeing a single day's production. But I need to see between two dates, so I can view it on a weekly basis as well.

The summary page has a data validation drop down with dates. I don't know what is easiest or best, if we can add a second drop down which allow a range or if just a separate sheet that did the same thing but for a range of dates.

Thoughts?

On sheet Result this code after the Button

Please Login or Register  to view this content.

Kind regards
Leo

Thank you. I think that will work perfectly!