I have a pivot table which is taking data from another sheet of the same file, at page filter I have date field which range from Jan 01, 2003 to Nov 30, 2012(format mm/dd/yyyy). How can I select data e.g. from Aug 01 2010 to Nov 30 2012. One way is to select each date one by one, is there any efficient way to do this.
Thanks
Bookmarks