grouping dialog box

[Marion]

I am working in pivot table and want to group my dates into months, but
cannot find, why the grouping dialog box is not available

 

[Debra Dalgleish]

If there are any blank cells in the date column, you won't be able to
group the dates in the pivot table.

http://www.contextures.com/xlPivot07.html

Or, if the dates are being treated as text, you won't be able to group
them. If so, you can change the dates back to numbers, as described here:

http://www.contextures.com/xlDataEntry03.html

 

[Marion]

Thanks, opened new worksheet and found error, date setting to the regional
setting on PC did not agree.