Forum Discussion
Very specific Calendar Date Table
Something is not adding up for me here. See attached PBIX. Are you sure it isn't 11/28/2018 and it is 14 periods of 28 days? Because the cycle of 28 days doesn't repeat on October 28th, the October date of the 28 repeating days is October 31st, not the 28th. See attached PBIX.
Yep, I stopped working on it when I encountered the issue with the dates. Figured I would clear that up before proceeding. Now that that is cleared up let me see what I can do with restarting the count. Shouldn't be that difficult, basically some kind of Mod 13 essentially, let me see.
Hello!
Were you able to figure it out?
I was able to add a column to figure out the years, every 364 days, the way you figured the periods for 28 days.
I am stuck now on the formula on how to restart the period count after 13 periods and the year count after 364 days.
I used a rank column to rank the days & then created a manual formula to assign years to between specific ranks. With only 4 years, this was not labor intensive. However, it is still a temporary solution.
Any help is appreciated.
Thanks!