Hi, I have a problem with my Pivot Table.

I have my Pivot Table range to capture the 5,000 rows where I have my Date because from time to time I will add new rows which will populate my Date with a formula.

My formula is set to be blank if there is nothing there, but that cell still comes up as COUNT in my pivot.. So I have 4200 items for empty cell in my Pivot showing up.

Does anyone know whether there is a workaround this?

Any help would be much appreciated!