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, 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.
