Dynamic Named Range and Pivot Tables - Blank Cells

Hi All,

I am having some trouble with a Pivot Table I am attempting to create.

To start off with, the data will always be Dynamic. There could be 100 rows, or there could be 34823 rows so a truly dynamic formula is needed.

This is the names range I have so far and it does work for drawing the information I need.

=OFFSET(AccessControl!$A$2,,,COUNTA(AccessControl!$A:$A),COUNTA(AccessControl!$2:$2))

Now the problem occurs when trying to group the dates on the pivot table. It seems that no matter what formula I try, a blank cell always appears at the bottom of the selection thus stopping me from grouping with the message "Cannot group that selection".

I have no idea how to get around this, and once it does start working the rest of the table I know I can do but it all rests on the date.

Thanks for any help!