View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
jason gers jason gers is offline
external usenet poster
 
Posts: 2
Default Pivot Table filtering dates

On Apr 13, 12:32 pm, KJ wrote:
XP w/ Excel 07
I've got a year's worth of orders. I need to create a PT that shows only
the orders placed in January. When I try to filter the dates it gives me an
option to click on individual dates, but I can't seem to enter a range of
dates.
Anyone got any suggestions??

Thanks.
Ken.


I would just set up the ranges in an additional column in the data
sheet, if possible.

jason