I am using an excel workbook as a means of scheduling staff. I can
enter their first name, week ending date, project number, and number
of hours scheduled via a userform I made. I have a couple of pivot
tables already set up, one sorts the hours by project, then by name,
the 2nd pivot table sorts name first, then project number. So far, so
good.

Now I have someone that wants me to make the pivot tables so that they
can see various date ranges, such as all the time worked in a given
month, or in the last 2 weeks, or from January to April.

Having taken only 1 VBA class, I know just enough to be dangerous.
Anyone have any ideas on how I can do this? Any help would be most
greatly appreciated!