Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
nicanova
Contributor III

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!

Labels (2)
3 Replies
marcus_sommer

Most of calendars are creatable within Qlik. The following would be a good starting point:

Non-Gregorian calendars - Qlik Community - 1471155

- Marcus

nicanova
Contributor III
Author

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.

marcus_sommer

Maybe one or two extra if-loops could adjust the existing script to your requirements ...

- Marcus