My team is working on some allocation numbers and I haven't been able to figure out how this calendar build should work. Each month/week grouping should start on the 1st of the month and count in 7 day (or less) increments until the end of each month. With this information, I will be able to allocate how many people need to be available per week and per month without having to worry about roll-overs between months.
I just can't figure out how to do the extra group of leftover days. Would it be a good place to start to group the day numbers to assign MonthName, Week1, Week2, Week3, Week4, Week5?