Can't group dates on my pivot chart

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

Hi,

Welcome to the Forum.

I have added a new column for month in the attached Pivot Table. Please see if this is what you are looking for.

Thanks cbatrody. That is a better way to make the pivot table calculate everything based on the month; and it lets me add dates with out glitching, and making duplicates of the same day.

You are welcome

If that takes care of your question, please mark this thread as Solved by selecting Thread Tools --> Mark thread as solved.