Trouble with ExcelPivotTableField.AddDateGrouping when some dates are blank

Mar 11, 2015 at 2:55 PM
I am having trouble using ExcelPivotTableField.AddDateGrouping when some of the dates in my spreadsheet are blank. When use the date grouping it "just doesn't work". No error, but no grouping is done at all.

I have determined that this only happens when there are blank fields.

Any ideas on how to work around?