I am using =IF(LEN(C17),(C17),"") to create my date columns. I want to be able to have columns from January - December shown in the pivot chart, even if there is no data yet. Also I can't group the dates by month to keep track of expenses for the whole year.

=IF(LEN(C17),(C17),"") is based off of =TODAY()

My pivot table consists of the company, date and expenses, and takes up space from row 2 to 5000.

po book test.xls