filtering weekends - pivot table?

[Watcher05]

Hi all,

I need to get how many transactions occur over a three month period for example but I only need Saturday's and Sunday's (about 35000 lines/transactions).

I tried to filter the info in a power pivot but the date filter won't let me do specific days. I've managed to get dates and a count column for daily transactions but filtering out the specific days doesn't seem that straight forward.

Once I get this information i will then put it into a pivot chart to compare the two days of transactions over the three months of weekends to see how busy these periods are.

Is there an easy way to do this? I'm not the greatest with formulas and am hoping it can be done via pivot tables!

thank you in advance

 

[Cross Terrier]

The easiest way is to fill the row above the dates with the formula =TEXT(A2,"dddd") and then use this data in the pivot table so you can filter on Saturday and Sunday.

Edit - Sorry, put that formula into a column alongside the date cells. I thought that the dates were on a row, but the formula is still good