Forum Discussion
RogerTangoXray
Feb 24, 2023Copper Contributor
looking for a scheduling calender
at my company we work a 14 days on and 7 days off schedule and i am looking to find an easier way to create the schedule than to manually do it every month. i found a excel template (employee absence schedule) it is close but i am needing the days of week to maintain but the date to shift. i imagine that there is a way to do that. so any help or a point in right direction would be appreciated
thanks
- peiyezhuBronze Contributormanually do it every month.
how you do it now?
can you share more details?- RogerTangoXrayCopper Contributorjust go manually select cells and change color for every month for each employee so 14 days on and 7 days off the days off starts sunday at midnight
- peiyezhuBronze Contributorhttps://techcommunity.microsoft.com/t5/excel/excel-calendar/m-p/3740226#M180590
I find a link for your reference.
I am not sure what you mean manually select cells and change color .
If possible,share your sample file.