Need Help Updating Pivot Table Source Data

Your pivot table should allow blanks in dates and still group. Are they really blanks or maybe "" from a formula?

You might need to attach a sample workbook.

You're right. They are "" from a formula. Not sure if its the most efficient way, but I just added a line to clear contents from the AX column if the cell = "". After that the above code worked for me.