Automate An AutoFilter Of Raw Data By Month/Year That's In Date Serial Format

[milwphil]

Good morning!

Does anyone have any suggestions, resources or example solutions of a macro that will allow me to Autofilter raw data by (MM/YYYY) that is received in the date serial (ddddd.tttttt) format?

Background
Basically, I have a user form that is intended act as a simple query interface. They essentially start with a comprehensive data set (year to date data) which is in the background. When they select the Month/Date range and Company the Autofilter macro runs to only run pivots (on visible worksheets) off of that data.

Example:
The user can select Quahog LLC or The Drunken Clam LLC or Combined...then they are provided a date range selection (MM/YYYY). The user selects enter and the raw data autofilters based on the selection.

I'm stuck....the date thing is really throwing me for a loop. If this is a huge effort and I'm over simplifying---that may need to be all the feedback I need to know.

However, if anyone has a suggestions on how to deal with the date filter, I'd be very appreciative!

Thanks in advance!
Phil