How to group dates in Excel Pivot Table by Weeks

Jim Bough 1 Reputation point

When I attempt to group my dates by days to show weeks the fields are grayed out.

Excel Management
Excel Management
Excel: A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.Management: The act or process of organizing, handling, directing or controlling something.
1,639 questions
{count} votes

5 answers

Sort by: Most helpful
  1. Dillon Silzer 54,291 Reputation points

    Hi @Jim Bough

    You will need to remove any record that has N/A in the filtering (or any record that does not follow the proper date structure.


    Once you have done this the capability to choose days will no longer be greyed out. Then you can choose 7 days (which will be you week filter).



    If this is helpful please accept answer.

    0 comments No comments

  2. Jim Bough 1 Reputation point

    I have done all that and still have the grayed out boxes.

    0 comments No comments

  3. Limitless Technology 39,341 Reputation points


    Are the date columns formatted in correct date format? If they’re not, they won’t allow grouping, filtering or any other date related function.


    --If the reply is helpful, please Upvote and Accept as answer--

    0 comments No comments

  4. Jim Bough 1 Reputation point

    Yes. All dates are in the Date Format.

    0 comments No comments

  5. Ceasar Chen_MSFT 4,391 Reputation points

    Hi, @Jim Bough
    Have you tried to refresh the pivot table after the change? Whether excel is up to date, it is recommended that you update to the new version.

    If the response is helpful, please click "Accept Answer" and upvote it.
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    0 comments No comments