- From Date x until date y
- Choose attributes Month, MonthName, Year, Week, Fiscal Year, …
- Fiscal Year starts at xxx
- Create hierarchy on x,y,z, …
- Create common date calculations (YTD, YOY, Y-1, …)
Recently I ran into an App for Excel 2013 which does a large part of this work. The App is called Create Time Dimension and is written by Stefan Johansson.
After you installed this free App from the Office App Store you can generate a Calendar dimension in a few seconds.
In the latest release the calendar can be generated in Dutch (next to English and Swedish).
A real time saver!