weekday in pivot table
 

In pivot tables, I know I can group dates by days, months, quarters, years.
But can I group by day of the week (i.e. Sunday, Monday, Tuesday, etc.)?

weekday in pivot table
 

Organize your data by day of the week BEFORE you put it in a Pivot Table.
Then, put everything in a Pivot Table and pivot by day of week.



--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.


"yowzers" wrote:

In pivot tables, I know I can group dates by days, months, quarters, years.
But can I group by day of the week (i.e. Sunday, Monday, Tuesday, etc.)?

weekday in pivot table
 

So there is no way for the pivot table to automatically do this for me? I
have dates in column A of my data sheet. In the pivot tables, excel just
reads these dates and automatically groups them by month, quarter, or year.
There is no way to do this for days of the week, correct?

"ryguy7272" wrote:

Organize your data by day of the week BEFORE you put it in a Pivot Table.
Then, put everything in a Pivot Table and pivot by day of week.



--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.


"yowzers" wrote:

In pivot tables, I know I can group dates by days, months, quarters, years.
But can I group by day of the week (i.e. Sunday, Monday, Tuesday, etc.)?

weekday in pivot table
 

In A2, I have =today()
So the value is 12/16/2009

In Column B I have Day; In Column C I have Month, In column D I have Year;

I just created a Pivot Table and grouped by: Month in Row and Year in
Column. Then, I put Count of Day in €˜Data Items. You can do pretty much
whatever you want to do with Pivot Tables. If it doesnt you the desired
results, change you r DATA! The Pivot Table is built off of the DATA. You
DATA may not be€¦atomic€¦meaning smallest possible units€¦and thus your Pivot
Table may not give you your desired results. Again, try to manipulate your
DATA, and then manipulate your PIVOT TABLE.

Good luck!


--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.


"yowzers" wrote:

So there is no way for the pivot table to automatically do this for me? I
have dates in column A of my data sheet. In the pivot tables, excel just
reads these dates and automatically groups them by month, quarter, or year.
There is no way to do this for days of the week, correct?

"ryguy7272" wrote:

Organize your data by day of the week BEFORE you put it in a Pivot Table.
Then, put everything in a Pivot Table and pivot by day of week.



--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.


"yowzers" wrote:

In pivot tables, I know I can group dates by days, months, quarters, years.
But can I group by day of the week (i.e. Sunday, Monday, Tuesday, etc.)?

weekday in pivot table
 

Excel 2007 PivotTable
Group by day of week.
http://www.mediafire.com/file/2j5xhttzzo3/12_16_09.xlsx