Sjacoexcelnovice
New Member
- Joined
- Mar 24, 2024
- Messages
- 1
- Office Version
- 365
- Platform
- Windows
Is it possible to make a period scheduler utilizing the "=SWITCH" functionality, or is there a better more efficient way? With option for static and rotating periods. This may be hard to understand but I will do my best to explain and use images to give a visual guide to who or whom may be able to help me (take on the challenge). I apologies ahead of time to all excel pros for any and all mistakes I make. I am very new to excel.
Basically, I use excel to make a period scheduler that, depending on availability, can either be static or rotational. This is not exactly what it looks like but what matters most is the best ways to make this work. Or, if it just simply not possible.
I will not be the only person using this as a tool so the end goal here is for this to be functional and easy to the lowest denominator. Please let me know if more info is needed, I'll be more than happy to answer any questions that may arise.
Basically, I use excel to make a period scheduler that, depending on availability, can either be static or rotational. This is not exactly what it looks like but what matters most is the best ways to make this work. Or, if it just simply not possible.
I will not be the only person using this as a tool so the end goal here is for this to be functional and easy to the lowest denominator. Please let me know if more info is needed, I'll be more than happy to answer any questions that may arise.
