I am putting together a chart template that will be distributed among warehouse associates to pick weeks of vacation. This is an ongoing project that I have several posts about but long story short, we currently use a program which might no longer be compatible with a Windows upgrade we are eventually getting here at work. I am trying to do in excel what this program exports to a chart in Excel based on the information that is def into that program. Here is a piece of what the template looks like that is this topic's concern:
Currently as you see, it will list the Month and then right below it the dates that begin the weeks in those months. What I am looking for is to see if there might be a way to automate the setup of future years. I am wondering if there might be a way to have it auto-rearrange months and dates based on the year entered or what current year we are in even.
The month of July for example as you see in 2021 is a month that has 4 beginning Sunday dates. Well in 2022, it has 5 beginning Sunday dates: 3,10,17,24, and 31. This would conflict with the current chart alignment because the 31st would go under the AUG. heading. The program that exports these charts somehow automatically realigns it to account for 5 Sunday months vs 4 Sunday months placing the Month names where appropriate, but I am just curious if there might be something in Excel that could do that? Any help/suggestions are appreciated.
Currently as you see, it will list the Month and then right below it the dates that begin the weeks in those months. What I am looking for is to see if there might be a way to automate the setup of future years. I am wondering if there might be a way to have it auto-rearrange months and dates based on the year entered or what current year we are in even.
The month of July for example as you see in 2021 is a month that has 4 beginning Sunday dates. Well in 2022, it has 5 beginning Sunday dates: 3,10,17,24, and 31. This would conflict with the current chart alignment because the 31st would go under the AUG. heading. The program that exports these charts somehow automatically realigns it to account for 5 Sunday months vs 4 Sunday months placing the Month names where appropriate, but I am just curious if there might be something in Excel that could do that? Any help/suggestions are appreciated.