Pivot Table - Group Columns by Custom Dates

Hi All,

Hoping someone would know the answer to this because Google certainly doesn't. I am not even sure if this is possible in Excel, but I am wondering is it possible to custom group values by between date in a Pivot table.

For example, I would like one column to show values between dates (01/07/2017 - 30/06/2018) and a second column to show dates between (01/01/2019 - 30/06/2019). In other words, I would like to use my own custom 'between' dates and have them displayed in separate columns.

My terrible Excel representation below:

Names | Column A (01/07/2017 - 30/06/2018) | Column B (01/01/2019 - 30/06/2019)

Hope someone knows the answer!

Hi Olly,

Thanks for your response. Glad to know that there is a solution to this.

If you could kindly elaborate slightly on the steps (sorry I'm still learning)

When you say create a 'Date column' do you mean in the source data or in the Pivot table? I am not sure how to create a column in the Pivot table?

Also, when I Group them in the pivot, which option should I be selecting Years, Quarters or Months? Also dates?

Would you be able to clarify more details also on how to do the below?
6. Remove Date from Columns (leaving Date2)
7. Filter Column Labels to include only Group1 and Group2.

Thanks again for your help