looking for a scheduling calender

Copper Contributor

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

3 Replies
manually do it every month.

how you do it now?
can you share more details?
just 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
https://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.