Share via

Excel Web - Group dates by week

Anonymous
2021-07-26T19:46:54+00:00

I am using Excel 365 web version and was wondering how to group dates by week? This is specifically for the cloud based excel version on windows.

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

Anonymous
2021-07-26T23:45:59+00:00

Hi,

May I know if this is similar to what you need? Here is a screenshot taken from my sample test just now to get grouped dates by weeks.

Image

If so, check Excel Pivot Tables - Grouping Dates by Week Within Months, Quarters or Years - Workaround - PakAccountants.com.

Disclaimer: Microsoft provides no assurances and/or warranties, implied or otherwise, and is not responsible for the information you receive from the third-party linked sites or any support related to technology.​

Let me know if you need any specific support about the steps to do it.

Best Regards,

Mia

Was this answer helpful?

0 comments

3 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2021-07-30T06:10:03+00:00

    Hi,

    Feel free to post back if you have any further concern.

    Best Regards,

    Mia

    Was this answer helpful?

    0 comments
  2. Anonymous
    2021-07-27T23:07:41+00:00

    Hi,

    There has no options for out-of-box features in Excel to group days, month and year. Neither in Excel desktop app nor Excel Online.

    We can only make a pivot table to realize it.

    Best Regards,

    Mia

    Was this answer helpful?

    0 comments
  3. Anonymous
    2021-07-27T08:16:13+00:00

    On the Web version of excel I can't see the grouping options of days,month and year.

    Was this answer helpful?

    0 comments