Date Selection for Pivot Table
 

I build some pivot tables for our laboratuary. They contains daily analysis
results. I want a solution to:
1-) User can enter week number and then daily analysis for that week appears
day by day on a pivot table.
Example: Input: 49 Output:29/11/2004--- 05/12/2004 on pivot table and
regarding data
2-) User can enter month and than daily analysis for that month appears day
by day on a pivot table.
Example: Input 11 Output:01/11/2004---30/11/2004 on pivot table and
regarding data
Thanks a lot