{"id":5737,"date":"2020-08-07T06:04:52","date_gmt":"2020-08-07T04:04:52","guid":{"rendered":"https:\/\/www.myexcelonline.com\/?p=5737"},"modified":"2024-03-22T18:58:45","modified_gmt":"2024-03-22T17:58:45","slug":"errors-when-grouping-by-dates-with-excel-pivot-tables","status":"publish","type":"post","link":"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/errors-when-grouping-by-dates-with-excel-pivot-tables\/","title":{"rendered":"Cannot group that selection in an Excel Pivot Table – SOLUTION!"},"content":{"rendered":"

Excel Pivot Table<\/a> Date Grouping is a very powerful feature<\/strong> in Excel that allows you to quickly group dates into years, quarters, months, weeks, days, hours, minutes and\/or seconds<\/strong>.<\/p>\n

However, there are times when Excel Pivot Table dates cannot group that selection and we get an error message: Cannot group that selection<\/em>.<\/strong><\/p>\n

\"Cannot<\/a><\/p>\n

 <\/p>\n

Instead of checking the dates one by one to find out where the error occurred, I will show you a quick way to fix the Cannot group that selection <\/strong><\/em>error message!<\/p>\n

 <\/p>\n

\n
\n

Table of Contents<\/p>\n<\/span><\/div>\n