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