Check out my Excel Guides on Retrieve: https://mrexcel.retrieve.com/#/

A question from the Las Vegas IMA: How do you do date rollups in Excel when the company is on a fiscal year that does not end on December 31?

This video shows how to use Power Query to link to a Calendar table. The pivot table uses the Data Model and you create a relationship.