Showing results for 
Search instead for 
Did you mean: 
Yojo Frequent Visitor
Frequent Visitor

13-month Calendar

Yay, another calendar post. I've found a lot of information on 445 and all that, but not the 13m/52w/364d ones.


So far, I've built my query so it loads up a calendar which continues from 2016 and covered things like start of week conditions, fiscal year conditions, etc. But getting day of week, week of year, and period (month) of year is very tough because of the conditions of a 13 period calendar. 


Here they are:

  1. Weekday starts Monday
  2. Fiscal Year starts July
  3. Fiscal year start is ISO meaning the starting week of fiscal year is when 1st July occurs on Mon-Thu. I.e. if 1st July is a Friday, the year will start the following Monday, 4th of July.
  4. Because the year is 364, some years will have a period that is 5-weeks in length at the start (or end) which prevents falling short

Any ideas?

Community Support Team
Community Support Team

Re: 13-month Calendar

Hi @Yojo ,


Would you please show us an example of your expected calendar output?



Yuliana Gu

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.