PowerPivotPro has The Ultimate Date Table–Revisited This is fantastic if you’re looking at things like reporting based on fiscal periods.
The Ultimate Date Table–Revisited « PowerPivotPro
Archived post from 2014. Dynamics GP and the links it points to have changed since; check current documentation before relying on version-specific steps.