
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Excel Calendar Template
I have to build a master calendar in Excel because our financial calendar is a non-standard variation of a 4-4-5. Is there an ideal format or list of columns that I should use or define? I've seen some lists of Year, Month, Week#, and Day, and another that just had year, Week#, number of days in a week, and start/end date. Since I have a blank slate to start from, I want to build it out in a format that will be the easiest to ingest/use.
thanks!


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Most of calendars are creatable within Qlik. The following would be a good starting point:
Non-Gregorian calendars - Qlik Community - 1471155
- Marcus

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Thanks, the problem is that we operate on a 4-4-5, but it always ends on 12/31. The script that is in those calendar posts from Henric can address one or the other (4-4-5 or broken weeks), but not both at the same time.


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Maybe one or two extra if-loops could adjust the existing script to your requirements ...
- Marcus
