• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Excel Newbie--want to do pivot table in excel 2010 without weekends

A

arena225

New Member
Hi I have a pivot table report that I run everyday and I would like to know how I can get the report to omit weekends. I am using Excel 2010. Thank you.
 
In your data, create a helper column with a formula like this:

=WEEKDAY(Date_Column,2)<6


Make sure you give the column a header, like "WEEKDAY ONLY"

Refresh your PivotTable (making sure the new column is included in PivotTable now)

Add the WEEKDAY_ONLY field to the Page_area, set it to TRUE to omit weekends.
 
You can select the date field of the pivot table and manually unselect them

or

Maybe add a new field to your data

DayNo: =WEEKDAY(Date,2)

and then in the pivot table you can filter your new field DayNo to be less than 6
 
You must log in or register to reply here.
Back
Top