Pivot Table won't Group Dates from growing Table

[BrerRabbit]

I have a table that is solely populated by formulae. Over the course of time more data will populate this table via the formulae.

The Date column does use the DateValue formula.

I'm trying to do a pivot table off this table.
If I do a pivot table where the range from the table is just the data then I can group the dates. BUT, the pivot table won't include new data.
If I do a pivot table where the range includes blank rows (only has formula in them) then the dates won't group bcuz there is a blank row included in the pivot table.

I don't know how to proceed.

 

[BrerRabbit]

You can probably use Data, From Table to massage your original data into the same structure you currently have for the Pivot table. The result of that automagically is a table and hence no issues with grouping.

That's my thought too.

 

[RoryA]

They would simply become additional fields in the pivot table field list.

 

[jkpieterse]

What RoryA means is add a column "Year" with the YEAR function to pull the year from the data and drag that new Year field to your pivot table's row area

 

[BrerRabbit]

They would simply become additional fields in the pivot table field list.

so I took your advice but went a step further. I did a lookup table that put the dates in my table for each financial quarter. Thank you for the suggestion. This worked a treat. I used this guy's lookup table.

excel 2013 date quarter function - Google Search