Hi,
I have a list of dates and data that go back a year. In Excel I made a pivot table that shows all these dates. In the columns label under data filters I see a lot of weekly, monthly, yearly information that is available but the one Im looking for is the one that will separate my dates by each month similar to the quarterly function.
Is this something I can do with in the pivot table function or would I need to do something else, and if I do can you give me some advice as to how I can do this,
Thanks for your time and help