I am using Excel 2016. I have a date field in the column and want to group by month and year. When I right click on a date and select Group I get a dialog box that says Can't Group That Selection??



I've checked and I don't seem to have any missing dates and the column in the data tab is formatted as a date field (although I am using an equation to get the date).



Any ideas would be greatly appreciated.