Changing Date ranges on Pivot Table

[tobysdhc]

Hello,

I am using a pivot table to summarize some date information (about 25,000 lines). I want to pull it by our fiscal year which runs from July to June, but the default is January to December. Is there any way to set it up to pull, for example, July 2016 to June 2017, as a year?

Thanks,

 

[sijpie]

Perhaps this can set you on the right track

A fiscal year function in Excel » Daljit Dhadwal

daljitdhadwal.com